DBA Data[Home] [Help]

APPS.PAY_AU_REC_DET_ARCHIVE dependencies on PER_PAY_PROPOSALS

Line 1572: per_pay_proposals pro,

1568: per_assignments_f paa,
1569: per_grades_tl pgr, /* Bug 3953702*/
1570: per_periods_of_service pps,
1571: per_pay_bases ppb,
1572: per_pay_proposals pro,
1573: per_assignment_status_types past,
1574: hr_soft_coding_keyflex hsc, /*Bug 4040688*/
1575: hr_organization_units hou, /*Bug 3953706 */
1576: hr_organization_units hou1 /*Bug 4132525*/

Line 1602: from per_pay_proposals pro1

1598: and pps.person_id = pap.person_id
1599: and pro.change_date(+) <= c_end_date
1600: and nvl(pro.approved,'Y') = 'Y'
1601: 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'))
1602: from per_pay_proposals pro1
1603: where pro1.assignment_id(+) = paa.assignment_id
1604: and pro1.change_date(+) <= c_end_date
1605: and nvl(pro1.approved,'Y')='Y');
1606: