APPS.PAY_AU_REC_DET_PAYSUM_MODE dependencies on PER_PAY_PROPOSALS

Line 1298: per_pay_proposals pro,

1294: per_assignments_f paa,
1295: per_grades_tl pgr,
1296: per_periods_of_service pps,
1297: per_pay_bases ppb,
1298: per_pay_proposals pro,
1299: per_assignment_status_types past,
1300: hr_all_organization_units hou,
1301: pay_assignment_actions paa1
1302: ,hr_soft_coding_keyflex hsc

Line 1330: from per_pay_proposals pro1

1326: and pps.person_id = pap.person_id
1327: and pro.change_date(+) <= c_end_date
1328: and nvl(pro.approved,'Y') = 'Y'
1329: 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'))
1330: from per_pay_proposals pro1
1331: where pro1.assignment_id(+) = paa.assignment_id
1332: and pro1.change_date(+) <= c_end_date
1333: and nvl(pro1.approved,'Y')='Y');
1334: