DBA Data[Home] [Help]

APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on PER_PAY_BASES

Line 8601: per_pay_bases ppb -- 2594204

8597: ,p_pay_basis_id number) is
8598: select (maximum * grade_annualization_factor) maximum ,
8599: (minimum * grade_annualization_factor) minimum
8600: from pay_grade_rules_f pgr,
8601: per_pay_bases ppb -- 2594204
8602: where ppb.pay_basis_id = p_pay_basis_id
8603: and ppb.business_group_id = p_business_group_id
8604: and pgr.rate_id = ppb.rate_id
8605: and pgr.business_group_id = p_business_group_id

Line 8620: from per_pay_bases ppb,

8616: ,p_business_group_id number
8617: ,p_lf_evt_ocrd_dt date
8618: ,p_pay_basis_id number) is
8619: select ppp.proposed_salary_n * ppb.pay_annualization_factor annual_salary
8620: from per_pay_bases ppb,
8621: per_pay_proposals ppp
8622: where ppb.pay_basis_id = p_pay_basis_id
8623: and ppb.business_group_id = p_business_group_id
8624: and ppp.assignment_id = p_assignment_id

Line 8644: from per_pay_bases ppb

8640: cursor c_pay_bas_ann_fctr ( p_pay_basis_id number
8641: ,p_business_group_id number
8642: ) is
8643: select ppb.pay_annualization_factor
8644: from per_pay_bases ppb
8645: where ppb.pay_basis_id = p_pay_basis_id
8646: and ppb.business_group_id = ppb.business_group_id;
8647: --
8648: l_ann_fctr number := 0;