APPS.PAY_US_PAYSLIP_SIMULATION_MAIN dependencies on PER_PAY_BASES

Line 4592: FROM per_pay_bases ppb,

4588: CURSOR get_pay_basis(cp_pay_basis_id NUMBER
4589: ,cp_effective_date DATE)
4590: IS
4591: SELECT ppb.name
4592: FROM per_pay_bases ppb,
4593: pay_input_values_f piv
4594: WHERE ppb.pay_basis_id = cp_pay_basis_id
4595: AND piv.input_value_id = ppb.input_value_id
4596: AND cp_effective_date BETWEEN piv.effective_start_date

Line 4634: lv_pay_basis per_pay_bases.name%TYPE;

4630: ln_payroll_id per_all_assignments_f.payroll_id%TYPE;
4631: ln_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
4632:
4633: lv_period_type pay_payrolls_f.period_type%TYPE;
4634: lv_pay_basis per_pay_bases.name%TYPE;
4635:
4636: ln_annual_salary NUMBER;
4637: ln_proposed_salary NUMBER;
4638: ln_pay_annualization_factor NUMBER;

Line 4891: FROM per_pay_bases ppb,

4887: OR
4888: ( pel.pay_basis_id IS NULL
4889: AND NOT EXISTS
4890: (SELECT ppb.pay_basis_id
4891: FROM per_pay_bases ppb,
4892: pay_input_values_f piv1
4893: WHERE piv1.element_type_id = pet.element_type_id
4894: AND ld_effective_date
4895: BETWEEN piv1.effective_start_date