DBA Data[Home] [Help]

APPS.PAY_GTNLOD_PKG dependencies on PQP_US_FF_FUNCTIONS

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

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

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

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

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: AND assignment_action_id = l_assignment_action_id
736: 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 pay_assignment_actions paa,
743: pay_us_emp_state_tax_rules_f state,

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

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

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

796: and ee_or_er_code = 'EE'
797: UNION ALL
798: SELECT 'EE Non W2 FIT Withheld',
799: '4' sub_class,
800: pqp_us_ff_functions.get_nonw2_bal('Non W2 FIT Withheld','run',paa.assignment_action_id,null,paa.tax_unit_id) run_value,
801: null,
802: null
803: FROM pay_assignment_actions paa
804: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = 'TRUE'

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

800: pqp_us_ff_functions.get_nonw2_bal('Non W2 FIT Withheld','run',paa.assignment_action_id,null,paa.tax_unit_id) run_value,
801: null,
802: null
803: FROM pay_assignment_actions paa
804: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = 'TRUE'
805: AND assignment_action_id = l_assignment_action_id
806: UNION ALL
807: SELECT 'EE Non W2 SIT Withheld',
808: '4',

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

805: AND assignment_action_id = l_assignment_action_id
806: UNION ALL
807: SELECT 'EE Non W2 SIT Withheld',
808: '4',
809: pqp_us_ff_functions.get_nonw2_bal('SIT Alien Withheld','run',paa.assignment_action_id,state.jurisdiction_code,paa.tax_unit_id) run_value,
810: null,
811: null
812: FROM pay_assignment_actions paa,
813: pay_us_emp_state_tax_rules_f state,

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

811: null
812: FROM pay_assignment_actions paa,
813: pay_us_emp_state_tax_rules_f state,
814: pay_payroll_actions ppa
815: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = 'TRUE'
816: AND state.assignment_id = paa.assignment_id
817: AND ppa.payroll_action_id = paa.payroll_action_id
818: AND paa.assignment_action_id =l_assignment_action_id
819: AND ppa.effective_date BETWEEN state.effective_start_date AND state.effective_end_date;

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

862: ' and ee_or_er_code = ''EE''
863: UNION ALL
864: SELECT ''EE Non W2 FIT Withheld'' ,
865: ''4'' sub_class,
866: pqp_us_ff_functions.get_nonw2_bal(''Non W2 FIT Withheld'',''run'',paa.assignment_action_id,null,paa.tax_unit_id) run_value,
867: null,
868: null
869: FROM pay_assignment_actions paa
870: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = ''TRUE''

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

866: pqp_us_ff_functions.get_nonw2_bal(''Non W2 FIT Withheld'',''run'',paa.assignment_action_id,null,paa.tax_unit_id) run_value,
867: null,
868: null
869: FROM pay_assignment_actions paa
870: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = ''TRUE''
871: AND assignment_action_id = '||l_assignment_action_id ||' UNION ALL
872: SELECT ''EE Non W2 SIT Withheld'' ,
873: ''4'',
874: 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 874: pqp_us_ff_functions.get_nonw2_bal(''SIT Alien Withheld'',''run'',paa.assignment_action_id,state.jurisdiction_code,paa.tax_unit_id) run_value,

870: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = ''TRUE''
871: AND assignment_action_id = '||l_assignment_action_id ||' UNION ALL
872: SELECT ''EE Non W2 SIT Withheld'' ,
873: ''4'',
874: pqp_us_ff_functions.get_nonw2_bal(''SIT Alien Withheld'',''run'',paa.assignment_action_id,state.jurisdiction_code,paa.tax_unit_id) run_value,
875: null,
876: null
877: FROM
878: pay_assignment_actions paa,

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

877: FROM
878: pay_assignment_actions paa,
879: pay_us_emp_state_tax_rules_f state,
880: pay_payroll_actions ppa
881: WHERE pqp_us_ff_functions.is_windstar(null,paa.assignment_id) = ''TRUE''
882: AND state.assignment_id = paa.assignment_id
883: AND ppa.payroll_action_id = paa.payroll_action_id
884: AND paa.assignment_action_id ='|| l_assignment_action_id||
885: ' AND ppa.effective_date BETWEEN state.effective_start_date AND state.effective_end_date';