DBA Data[Home] [Help]

APPS.PAY_US_PSD_XML dependencies on PAY_POPULATION_RANGES

Line 1603: pay_population_ranges ppr

1599: ppa.effective_date effective_end_date
1600: FROM per_all_assignments_f ASG,
1601: pay_assignment_actions paa,
1602: pay_payroll_actions ppa,
1603: pay_population_ranges ppr
1604: WHERE ppa.effective_date between l_period_start
1605: and l_period_end
1606: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
1607: and paa.payroll_action_id = ppa.payroll_action_id

Line 1676: pay_population_ranges ppr

1672: paa.assignment_action_id act_id
1673: FROM per_all_assignments_f ASG,
1674: pay_assignment_actions paa,
1675: pay_payroll_actions ppa,
1676: pay_population_ranges ppr
1677: WHERE ppa.effective_date= l_period_end
1678: and ppa.report_type = 'YREND'
1679: and paa.payroll_action_id = ppa.payroll_action_id
1680: and paa.assignment_id = ASG.assignment_id