DBA Data[Home] [Help]

APPS.PAY_GB_EOY_MAGTAPE dependencies on PAY_ALL_PAYROLLS_F

Line 797: pay_all_payrolls_f ppf,

793: org HR_ORGANIZATION_INFORMATIO_FK1)
794: USE_NL(asg,ppf,flex,org) */
795: distinct asg.assignment_id, asg.effective_start_date, asg.effective_end_date
796: FROM per_all_assignments_f asg,
797: pay_all_payrolls_f ppf,
798: hr_soft_coding_keyflex flex,
799: hr_organization_information org
800: WHERE asg.person_id = p_person_id
801: AND asg.effective_end_date >= p_min_start_year_date

Line 825: pay_all_payrolls_f ppf,

821: org HR_ORGANIZATION_INFORMATIO_FK1)
822: USE_NL(asg,ppf,flex,org) */
823: distinct asg.assignment_id, asg.effective_start_date, asg.effective_end_date
824: FROM per_all_assignments_f asg,
825: pay_all_payrolls_f ppf,
826: hr_soft_coding_keyflex flex,
827: hr_organization_information org
828: WHERE asg.person_id = p_person_id
829: AND asg.effective_end_date >= p_min_start_year_date