DBA Data[Home] [Help]

APPS.PAY_GB_RTI_FPS_ARCHIVE dependencies on PAY_PAYROLLS_F

Line 289: pay_payrolls_f pay,

285:
286: cursor csr_asg is
287: select paaf.assignment_id
288: from per_all_assignments_f paaf,
289: pay_payrolls_f pay,
290: hr_soft_coding_keyflex sck
291: where paaf.person_id = (select distinct person_id from per_all_assignments_f where ASSIGNMENT_ID =p_assignment_id)
292: and pay.payroll_id = paaf.payroll_id
293: and pay.SOFT_CODING_KEYFLEX_ID = sck.SOFT_CODING_KEYFLEX_ID

Line 13213: from pay_payrolls_f ppf,pay_payroll_actions ppapre,pay_payroll_actions ppa

13209:
13210: CURSOR csr_payroll_details
13211: IS
13212: SELECT ppf.PAYROLL_NAME , ppapre.EFFECTIVE_DATE
13213: from pay_payrolls_f ppf,pay_payroll_actions ppapre,pay_payroll_actions ppa
13214: WHERE ppa.payroll_action_id = pactid
13215: and ppf.payroll_id = SUBSTR(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'PAYROLL_ID'),1,20)
13216: and ppapre.payroll_action_id = SUBSTR(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'PRE_PAY_ID'),1,20);
13217: