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 1126: ,per_pay_bases BASES

1122: cursor c_get_salary_basis_element(cp_assignment_id number,
1123: cp_date in date) is
1124: select ETYPE.element_type_id, ETYPE.element_name
1125: from per_all_assignments_f ASSIGN
1126: ,per_pay_bases BASES
1127: ,pay_input_values_f INPUTV
1128: ,pay_element_types_f ETYPE
1129: ,pay_rates RATE
1130: where cp_date BETWEEN ASSIGN.effective_start_date