DBA Data[Home] [Help]

APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on PER_PAY_BASES

Line 8583: per_pay_bases ppb -- 2594204

8579: ,p_pay_basis_id number) is
8580: select (maximum * grade_annualization_factor) maximum ,
8581: (minimum * grade_annualization_factor) minimum
8582: from pay_grade_rules_f pgr,
8583: per_pay_bases ppb -- 2594204
8584: where ppb.pay_basis_id = p_pay_basis_id
8585: and ppb.business_group_id = p_business_group_id
8586: and pgr.rate_id = ppb.rate_id
8587: and pgr.business_group_id = p_business_group_id

Line 8602: from per_pay_bases ppb,

8598: ,p_business_group_id number
8599: ,p_lf_evt_ocrd_dt date
8600: ,p_pay_basis_id number) is
8601: select ppp.proposed_salary_n * ppb.pay_annualization_factor annual_salary
8602: from per_pay_bases ppb,
8603: per_pay_proposals ppp
8604: where ppb.pay_basis_id = p_pay_basis_id
8605: and ppb.business_group_id = p_business_group_id
8606: and ppp.assignment_id = p_assignment_id

Line 8626: from per_pay_bases ppb

8622: cursor c_pay_bas_ann_fctr ( p_pay_basis_id number
8623: ,p_business_group_id number
8624: ) is
8625: select ppb.pay_annualization_factor
8626: from per_pay_bases ppb
8627: where ppb.pay_basis_id = p_pay_basis_id
8628: and ppb.business_group_id = ppb.business_group_id;
8629: --
8630: l_ann_fctr number := 0;