DBA Data[Home] [Help]

APPS.PAY_AU_REC_DET_ARCHIVE dependencies on PER_PAY_PROPOSALS

Line 2771: per_pay_proposals pro,

2767: per_assignments_f paa,
2768: per_grades_tl pgr, /* Bug 3953702*/
2769: per_periods_of_service pps,
2770: per_pay_bases ppb,
2771: per_pay_proposals pro,
2772: per_assignment_status_types past,
2773: hr_soft_coding_keyflex hsc, /*Bug 4040688*/
2774: hr_all_organization_units hou, /*Bug 3953706 */
2775: hr_all_organization_units hou1 /*Bug 4132525*/

Line 2801: from per_pay_proposals pro1

2797: and pps.person_id = pap.person_id
2798: and pro.change_date(+) <= c_end_date
2799: and nvl(pro.approved,'Y') = 'Y'
2800: and nvl(pro.change_date,to_date('4712/12/31','YYYY/MM/DD')) = (select nvl(max(pro1.change_date),to_date('4712/12/31','YYYY/MM/DD'))
2801: from per_pay_proposals pro1
2802: where pro1.assignment_id(+) = paa.assignment_id
2803: and pro1.change_date(+) <= c_end_date
2804: and nvl(pro1.approved,'Y')='Y');
2805: