DBA Data[Home] [Help]

APPS.PAY_US_PAYROLL_UTILS dependencies on PAY_PAYROLLS_F

Line 1090: pay_payrolls_f ppf

1086: ,cp_payroll_id in number) is
1087: select nvl(min(assignment_action_id),-1)
1088: from pay_assignment_actions paa,
1089: pay_payroll_actions ppa,
1090: pay_payrolls_f ppf
1091: where ppa.business_group_id +0 = cp_business_group_id
1092: and ppa.payroll_action_id = paa.payroll_action_id
1093: and ppa.effective_date between cp_start_date and cp_end_date
1094: and ppa.action_type in ('R','Q','I','B','V')