DBA Data[Home] [Help]

APPS.PAY_FR_GENERAL dependencies on PAY_PAYROLL_ACTIONS

Line 81: from pay_payroll_actions ppa

77:
78:
79: cursor pay_asg_act_csr is
80: select paa.assignment_action_id, ppa.effective_date
81: from pay_payroll_actions ppa
82: , pay_assignment_actions paa
83: , pay_run_results prr
84: where ppa.business_group_id = p_business_group_id
85: and ppa.action_type in ('Q','R')

Line 2393: pay_payroll_actions ppa,

2389: cursor csr_get_time_period is
2390: select ptp2.start_date,
2391: ptp2.end_date
2392: from per_time_periods ptp,
2393: pay_payroll_actions ppa,
2394: per_time_periods ptp2
2395: where ppa.date_earned BETWEEN ptp.START_DATE and ptp.END_DATE
2396: and ppa.payroll_action_id = p_payroll_action_id
2397: and ptp.payroll_id = ppa.payroll_id