DBA Data[Home] [Help]

APPS.PAY_FF_FUNCTIONS dependencies on PER_PAY_BASES

Line 541: per_pay_bases ppb,

537: nvl(ppb.pay_annualization_factor,tpt.number_per_fiscal_year) last_anul_sal
538: FROM per_people_f per,
539: per_time_period_types tpt,
540: per_assignments_f ass,
541: per_pay_bases ppb,
542: per_pay_proposals pro,
543: pay_all_payrolls_f prl
544: WHERE per.person_id = ass.person_id
545: AND ass.pay_basis_id = ppb.pay_basis_id

Line 1105: ,per_pay_bases BASES

1101: cursor c_get_salary_basis_element(cp_assignment_id number,
1102: cp_date in date) is
1103: select ETYPE.element_type_id, ETYPE.element_name
1104: from per_all_assignments_f ASSIGN
1105: ,per_pay_bases BASES
1106: ,pay_input_values_f INPUTV
1107: ,pay_element_types_f ETYPE
1108: ,pay_rates RATE
1109: where cp_date BETWEEN ASSIGN.effective_start_date