DBA Data[Home] [Help]

APPS.PAY_CA_PAYRG_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 147: pay_all_payrolls_f ppf

143: per_assignments_f paf,
144: pay_payroll_actions ppa, /* pre-payments and reversals
145: payroll action id */
146: pay_payroll_actions ppa1, /* PYUGEN payroll action id */
147: pay_all_payrolls_f ppf
148: where ppa1.payroll_action_id = pactid
149: and ((ppf.payroll_id = cp_payroll_id) OR
150: (cp_payroll_id is null))
151: and paf.business_group_id = cp_bg_id

Line 220: pay_all_payrolls_f ppf

216: cursor c_get_map_flag(cp_prepay_action_id number) is
217: select ppf.multi_assignments_flag
218: from pay_assignment_actions paa,
219: pay_payroll_actions ppa,
220: pay_all_payrolls_f ppf
221: where assignment_action_id = cp_prepay_action_id
222: and ppa.payroll_action_id = paa.payroll_action_id
223: and ppf.payroll_id = ppa.payroll_id
224: and ppa.effective_date between ppf.effective_start_date