DBA Data[Home] [Help]

APPS.BEN_EVALUATE_RATE_PROFILES dependencies on PER_PAY_BASES

Line 6575: per_pay_bases ppb -- 2594204

6571: ,p_pay_basis_id number) is
6572: select (maximum * grade_annualization_factor) maximum ,
6573: (minimum * grade_annualization_factor) minimum
6574: from pay_grade_rules_f pgr,
6575: per_pay_bases ppb -- 2594204
6576: where ppb.pay_basis_id = p_pay_basis_id
6577: and ppb.business_group_id = p_business_group_id
6578: and pgr.rate_id = ppb.rate_id
6579: and pgr.business_group_id = p_business_group_id

Line 6595: from per_pay_bases ppb,

6591: ,p_business_group_id number
6592: ,p_lf_evt_ocrd_dt date
6593: ,p_pay_basis_id number) is
6594: select ppp.proposed_salary_n * ppb.pay_annualization_factor annual_salary
6595: from per_pay_bases ppb,
6596: per_pay_proposals ppp
6597: where ppb.pay_basis_id = p_pay_basis_id
6598: and ppb.business_group_id = p_business_group_id
6599: and ppp.assignment_id = p_assignment_id

Line 6620: from per_pay_bases ppb

6616: cursor c_pay_bas_ann_fctr ( p_pay_basis_id number
6617: ,p_business_group_id number
6618: ) is
6619: select ppb.pay_annualization_factor
6620: from per_pay_bases ppb
6621: where ppb.pay_basis_id = p_pay_basis_id
6622: and ppb.business_group_id = ppb.business_group_id;
6623: --
6624: procedure get_quartile(p_min IN number default 0