APPS.PAY_AU_REC_DET_PAYSUM_MODE dependencies on PER_PAY_PROPOSALS

Line 924: per_pay_proposals pro,

920: per_assignments_f paa,
921: per_grades_tl pgr,
922: per_periods_of_service pps,
923: per_pay_bases ppb,
924: per_pay_proposals pro,
925: per_assignment_status_types past,
926: hr_organization_units hou,
927: pay_assignment_actions paa1
928: ,hr_soft_coding_keyflex hsc

Line 956: from per_pay_proposals pro1

952: and pps.person_id = pap.person_id
953: and pro.change_date(+) <= c_end_date
954: and nvl(pro.approved,'Y') = 'Y'
955: 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'))
956: from per_pay_proposals pro1
957: where pro1.assignment_id(+) = paa.assignment_id
958: and pro1.change_date(+) <= c_end_date
959: and nvl(pro1.approved,'Y')='Y');
960: