DBA Data[Home] [Help]

APPS.PAY_NL_WTS_REPORT dependencies on PER_ASSIGNMENTS_F

Line 241: per_assignments_f paa,

237: paa.person_id,
238: ppa.date_earned,
239: ppa.payroll_id
240: from
241: per_assignments_f paa,
242: pay_payroll_actions ppa,
243: per_people_f pap,
244: hr_organization_units hou,
245: hr_organization_units hou1,

Line 328: per_assignments_f paa,

324: Get_Element_Type_Id('Wage Tax Subsidy Education'),2,
325: Get_Element_Type_Id('Wage Tax Subsidy Long Term Unemployed'),3,
326: Get_Element_Type_Id('Wage Tax Subsidy Paid Parental Leave'),4) Sequence
327: from
328: per_assignments_f paa,
329: pay_payroll_actions ppa,
330: per_people_f pap,
331: pay_assignment_actions asg_act,
332: pay_run_results prr,

Line 395: per_assignments_f paa,

391: decode(prr.element_type_id,
392: Get_Element_Type_Id('Retro Wage Tax Subsidy Low Wages'),1,Get_Element_Type_Id('Retro Wage Tax Subsidy Long Term Unemployed'),3,
393: Get_Element_Type_Id('Retro Wage Tax Subsidy Education'),2,Get_Element_Type_Id('Retro Wage Tax Subsidy Paid Parental Leave'),4) Sequence
394: from
395: per_assignments_f paa,
396: per_people_f pap,
397: pay_assignment_actions asg_act,
398: pay_run_results prr,
399: pay_payroll_actions ppa,

Line 774: per_assignments_f paa,

770: paa.person_id,
771: ppa.date_earned,
772: ppa.payroll_id
773: from
774: per_assignments_f paa,
775: pay_payroll_actions ppa,
776: per_people_f pap,
777: hr_organization_units hou,
778: hr_organization_units hou1,

Line 884: per_assignments_f paa,

880: ,Get_Element_Type_Id('Wage Tax Subsidy EVC'),5
881: --RSS
882: ) Sequence
883: from
884: per_assignments_f paa,
885: pay_payroll_actions ppa,
886: per_people_f pap,
887: pay_assignment_actions asg_act,
888: pay_run_results prr,

Line 986: per_assignments_f paa,

982: ,Get_Element_Type_Id('Retro Wage Tax Subsidy EVC'),5
983: --RSS
984: ) Sequence
985: from
986: per_assignments_f paa,
987: per_people_f pap,
988: pay_assignment_actions asg_act,
989: pay_run_results prr,
990: pay_payroll_actions ppa,