APPS.BEN_CWB_DATA_MODEL_UPGRADE dependencies on PER_PAY_PROPOSALS

Line 519: 'PER_PAY_PROPOSALS',prv.pk_id,null) pay_proposal_id

515: ,rc.incrmt_elcn_val rec_incr_val
516: ,ws.val_last_upd_date ws_val_upd_date
517: ,ws.val_last_upd_person_id ws_val_last_upd_by
518: ,decode(prv.pk_id_table_name,
519: 'PER_PAY_PROPOSALS',prv.pk_id,null) pay_proposal_id
520: ,prv.element_entry_value_id
521: ,pil.person_id
522: ,popl.assignment_id
523: ,nvl(prv.rt_strt_dt, ws.rt_strt_dt)

Line 1106: ,per_pay_proposals ppp

1102: ,ben_per_in_ler pil
1103: ,per_all_people_f supv
1104: ,per_business_groups bg
1105: ,per_periods_of_service service_period
1106: ,per_pay_proposals ppp
1107: ,pay_all_payrolls_f pay
1108: ,ben_cwb_person_info pers
1109: ,(select rtg1.review_date review_date
1110: ,rtg1.performance_rating performance_rating

Line 1141: from per_pay_proposals ppp1

1137: and ppp.change_date (+) <= p_lf_evt_ocrd_dt
1138: and nvl(ppp.change_date,to_date('4712/12/31', 'yyyy/mm/dd')) =
1139: (select nvl(max(ppp1.change_date), to_date('4712/12/31',
1140: 'yyyy/mm/dd'))
1141: from per_pay_proposals ppp1
1142: where ppp1.assignment_id = ppp.assignment_id
1143: and ppp1.change_date <= p_lf_evt_ocrd_dt
1144: and ppp1.approved = 'Y')
1145: and paf.payroll_id = pay.payroll_id (+)