APPS.BEN_PRO_LER dependencies on PER_PAY_PROPOSALS

Line 53: from per_pay_proposals

49: -- Bug 5203589
50: cursor c_old_ppp
51: is
52: select *
53: from per_pay_proposals
54: where pay_proposal_id = p_old.pay_proposal_id;
55: --
56: l_old_ppp_rec c_old_ppp%rowtype;
57: --

Line 71: where source_table = 'PER_PAY_PROPOSALS'

67: and ((exists
68: (select 1
69: from ben_per_info_chg_cs_ler_f psl
70: , ben_ler_per_info_cs_ler_f lpl
71: where source_table = 'PER_PAY_PROPOSALS'
72: and psl.per_info_chg_cs_ler_id = lpl.per_info_chg_cs_ler_id
73: and lpl.business_group_id = psl.business_group_id
74: and lpl.business_group_id = ler.business_group_id
75: and l_session_date between psl.effective_start_date

Line 85: where source_table = 'PER_PAY_PROPOSALS'

81: OR (exists
82: (select 1
83: from ben_rltd_per_chg_cs_ler_f rpc
84: , ben_ler_rltd_per_cs_ler_f lrp
85: where source_table = 'PER_PAY_PROPOSALS'
86: and lrp.business_group_id = rpc.business_group_id
87: and lrp.business_group_id = ler.business_group_id
88: and l_session_date between rpc.effective_start_date
89: and rpc.effective_end_date

Line 108: and source_table = 'PER_PAY_PROPOSALS'

104: and psl.effective_end_date
105: and l_session_date between lpl.effective_start_date
106: and lpl.effective_end_date
107: and psl.per_info_chg_cs_ler_id = lpl.per_info_chg_cs_ler_id
108: and source_table = 'PER_PAY_PROPOSALS'
109: UNION
110: select rpc.source_column, rpc.new_val, rpc.old_val, 'R', rpc.rltd_per_chg_cs_ler_rl per_info_chg_cs_ler, rpc.rule_overrides_flag, lrp.chg_mandatory_cd
111: from ben_ler_rltd_per_cs_ler_f lrp, ben_rltd_per_chg_cs_ler_f rpc
112: where lrp.ler_id = p_ler_id and

Line 120: and source_table = 'PER_PAY_PROPOSALS'

116: and rpc.effective_end_date
117: and l_session_date between lrp.effective_start_date
118: and lrp.effective_end_date
119: and rpc.rltd_per_chg_cs_ler_id = lrp.rltd_per_chg_cs_ler_id
120: and source_table = 'PER_PAY_PROPOSALS'
121: order by 1;
122: --
123: cursor get_contacts(p_person_id in number) is
124: select person_id

Line 1045: per_pay_proposals ppp

1041: ,p_pay_basis_id number
1042: ,p_old_new varchar2) is
1043: select ppp.proposed_salary_n * ppb.pay_annualization_factor annual_salary,ppp.change_date
1044: from per_pay_bases ppb,
1045: per_pay_proposals ppp
1046: where ppb.pay_basis_id = p_pay_basis_id
1047: and ppb.business_group_id = p_business_group_id
1048: and ppp.assignment_id = p_assignment_id
1049: and ppp.approved = 'Y'

Line 1055: per_pay_proposals ppp

1051: and (p_called_from = 'A' or (p_called_from = 'P' and p_old_new = 'new') )
1052: union
1053: select ppp.proposed_salary_n * ppb.pay_annualization_factor annual_salary,ppp.change_date
1054: from per_pay_bases ppb,
1055: per_pay_proposals ppp
1056: where ppb.pay_basis_id = p_pay_basis_id
1057: and ppb.business_group_id = p_business_group_id
1058: and ppp.assignment_id = p_assignment_id
1059: and ppp.approved = 'Y'