eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GTNLOD_PKG dependencies on PQP_US_FF_FUNCTIONS

Line 614: pqp_us_ff_functions.get_nonw2_bal('Non W2 FIT Withheld','run',paa.assignment_action_id,null,paa.tax_unit_id) run_value,

610: and ee_or_er_code = 'EE'
611: UNION ALL
612: SELECT 'EE Non W2 FIT Withheld',
613: '4' sub_class,
614: pqp_us_ff_functions.get_nonw2_bal('Non W2 FIT Withheld','run',paa.assignment_action_id,null,paa.tax_unit_id) run_value,
615: null,
616: null
617: FROM pay_assignment_actions paa
618: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = 'TRUE'

Line 618: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = 'TRUE'

614: pqp_us_ff_functions.get_nonw2_bal('Non W2 FIT Withheld','run',paa.assignment_action_id,null,paa.tax_unit_id) run_value,
615: null,
616: null
617: FROM pay_assignment_actions paa
618: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = 'TRUE'
619: AND assignment_action_id = l_assignment_action_id
620: UNION ALL
621: SELECT 'EE Non W2 SIT Withheld',
622: '4',

Line 623: pqp_us_ff_functions.get_nonw2_bal('SIT Alien Withheld','run',paa.assignment_action_id,state.jurisdiction_code,paa.tax_unit_id) run_value,

619: AND assignment_action_id = l_assignment_action_id
620: UNION ALL
621: SELECT 'EE Non W2 SIT Withheld',
622: '4',
623: pqp_us_ff_functions.get_nonw2_bal('SIT Alien Withheld','run',paa.assignment_action_id,state.jurisdiction_code,paa.tax_unit_id) run_value,
624: null,
625: null
626: FROM pay_assignment_actions paa,
627: pay_us_emp_state_tax_rules_f state,

Line 629: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = 'TRUE'

625: null
626: FROM pay_assignment_actions paa,
627: pay_us_emp_state_tax_rules_f state,
628: pay_payroll_actions ppa
629: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = 'TRUE'
630: AND state.assignment_id = paa.assignment_id
631: AND ppa.payroll_action_id = paa.payroll_action_id
632: AND paa.assignment_action_id =l_assignment_action_id
633: AND ppa.effective_date BETWEEN state.effective_start_date AND state.effective_end_date;

Line 666: pqp_us_ff_functions.get_nonw2_bal('Non W2 FIT Withheld','run',paa.assignment_action_id,null,paa.tax_unit_id) run_value,

662: and ee_or_er_code = 'EE'
663: UNION ALL
664: SELECT 'EE Non W2 FIT Withheld',
665: '4' sub_class,
666: pqp_us_ff_functions.get_nonw2_bal('Non W2 FIT Withheld','run',paa.assignment_action_id,null,paa.tax_unit_id) run_value,
667: null,
668: null
669: FROM pay_assignment_actions paa
670: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = 'TRUE'

Line 670: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = 'TRUE'

666: pqp_us_ff_functions.get_nonw2_bal('Non W2 FIT Withheld','run',paa.assignment_action_id,null,paa.tax_unit_id) run_value,
667: null,
668: null
669: FROM pay_assignment_actions paa
670: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = 'TRUE'
671: AND assignment_action_id = l_assignment_action_id
672: UNION ALL
673: SELECT 'EE Non W2 SIT Withheld',
674: '4',

Line 675: pqp_us_ff_functions.get_nonw2_bal('SIT Alien Withheld','run',paa.assignment_action_id,state.jurisdiction_code,paa.tax_unit_id) run_value,

671: AND assignment_action_id = l_assignment_action_id
672: UNION ALL
673: SELECT 'EE Non W2 SIT Withheld',
674: '4',
675: pqp_us_ff_functions.get_nonw2_bal('SIT Alien Withheld','run',paa.assignment_action_id,state.jurisdiction_code,paa.tax_unit_id) run_value,
676: null,
677: null
678: FROM pay_assignment_actions paa,
679: pay_us_emp_state_tax_rules_f state,

Line 681: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = 'TRUE'

677: null
678: FROM pay_assignment_actions paa,
679: pay_us_emp_state_tax_rules_f state,
680: pay_payroll_actions ppa
681: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = 'TRUE'
682: AND state.assignment_id = paa.assignment_id
683: AND ppa.payroll_action_id = paa.payroll_action_id
684: AND paa.assignment_action_id =l_assignment_action_id
685: AND ppa.effective_date BETWEEN state.effective_start_date AND state.effective_end_date;

Line 731: pqp_us_ff_functions.get_nonw2_bal(''Non W2 FIT Withheld'',''run'',paa.assignment_action_id,null,paa.tax_unit_id) run_value,

727: ' and ee_or_er_code = ''EE''
728: UNION ALL
729: SELECT ''EE Non W2 FIT Withheld'' ,
730: ''4'' sub_class,
731: pqp_us_ff_functions.get_nonw2_bal(''Non W2 FIT Withheld'',''run'',paa.assignment_action_id,null,paa.tax_unit_id) run_value,
732: null,
733: null
734: FROM pay_assignment_actions paa
735: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = ''TRUE''

Line 735: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = ''TRUE''

731: pqp_us_ff_functions.get_nonw2_bal(''Non W2 FIT Withheld'',''run'',paa.assignment_action_id,null,paa.tax_unit_id) run_value,
732: null,
733: null
734: FROM pay_assignment_actions paa
735: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = ''TRUE''
736: AND assignment_action_id = '||l_assignment_action_id ||' UNION ALL
737: SELECT ''EE Non W2 SIT Withheld'' ,
738: ''4'',
739: pqp_us_ff_functions.get_nonw2_bal(''SIT Alien Withheld'',''run'',paa.assignment_action_id,state.jurisdiction_code,paa.tax_unit_id) run_value,

Line 739: pqp_us_ff_functions.get_nonw2_bal(''SIT Alien Withheld'',''run'',paa.assignment_action_id,state.jurisdiction_code,paa.tax_unit_id) run_value,

735: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = ''TRUE''
736: AND assignment_action_id = '||l_assignment_action_id ||' UNION ALL
737: SELECT ''EE Non W2 SIT Withheld'' ,
738: ''4'',
739: pqp_us_ff_functions.get_nonw2_bal(''SIT Alien Withheld'',''run'',paa.assignment_action_id,state.jurisdiction_code,paa.tax_unit_id) run_value,
740: null,
741: null
742: FROM
743: pay_assignment_actions paa,

Line 746: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = ''TRUE''

742: FROM
743: pay_assignment_actions paa,
744: pay_us_emp_state_tax_rules_f state,
745: pay_payroll_actions ppa
746: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = ''TRUE''
747: AND state.assignment_id = paa.assignment_id
748: AND ppa.payroll_action_id = paa.payroll_action_id
749: AND paa.assignment_action_id ='|| l_assignment_action_id||
750: ' AND ppa.effective_date BETWEEN state.effective_start_date AND state.effective_end_date';