DBA Data[Home] [Help]

APPS.BEN_PRO_LER dependencies on PER_PAY_BASES

Line 1029: per_pay_bases ppb

1025: ,p_pay_basis_id number) is
1026: select (maximum * grade_annualization_factor) maximum ,
1027: (minimum * grade_annualization_factor) minimum
1028: from pay_grade_rules_f pgr,
1029: per_pay_bases ppb
1030: where ppb.pay_basis_id = p_pay_basis_id
1031: and ppb.business_group_id = p_business_group_id
1032: and pgr.rate_id = ppb.rate_id
1033: and pgr.business_group_id = p_business_group_id

Line 1044: from per_pay_bases ppb,

1040: ,p_lf_evt_ocrd_dt date
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

Line 1054: from per_pay_bases ppb,

1050: and ppp.change_date <= p_lf_evt_ocrd_dt
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