DBA Data[Home] [Help]

APPS.BEN_EVALUATE_RATE_PROFILES dependencies on PER_PAY_BASES

Line 6518: per_pay_bases ppb -- 2594204

6514: ,p_pay_basis_id number) is
6515: select (maximum * grade_annualization_factor) maximum ,
6516: (minimum * grade_annualization_factor) minimum
6517: from pay_grade_rules_f pgr,
6518: per_pay_bases ppb -- 2594204
6519: where ppb.pay_basis_id = p_pay_basis_id
6520: and ppb.business_group_id = p_business_group_id
6521: and pgr.rate_id = ppb.rate_id
6522: and pgr.business_group_id = p_business_group_id

Line 6538: from per_pay_bases ppb,

6534: ,p_business_group_id number
6535: ,p_lf_evt_ocrd_dt date
6536: ,p_pay_basis_id number) is
6537: select ppp.proposed_salary_n * ppb.pay_annualization_factor annual_salary
6538: from per_pay_bases ppb,
6539: per_pay_proposals ppp
6540: where ppb.pay_basis_id = p_pay_basis_id
6541: and ppb.business_group_id = p_business_group_id
6542: and ppp.assignment_id = p_assignment_id

Line 6563: from per_pay_bases ppb

6559: cursor c_pay_bas_ann_fctr ( p_pay_basis_id number
6560: ,p_business_group_id number
6561: ) is
6562: select ppb.pay_annualization_factor
6563: from per_pay_bases ppb
6564: where ppb.pay_basis_id = p_pay_basis_id
6565: and ppb.business_group_id = ppb.business_group_id;
6566: --
6567: procedure get_quartile(p_min IN number default 0