APPS.PAY_US_PAYSLIP_SIMULATION_MAIN dependencies on PAY_PAYROLLS_F

Line 4565: FROM pay_payrolls_f ppf

4561: CURSOR get_period_type(cp_payroll_id NUMBER,
4562: cp_effective_date DATE)
4563: IS
4564: SELECT ppf.period_type
4565: FROM pay_payrolls_f ppf
4566: WHERE ppf.payroll_id = cp_payroll_id
4567: AND cp_effective_date BETWEEN ppf.effective_start_date
4568: AND ppf.effective_end_date;
4569:

Line 4633: lv_period_type pay_payrolls_f.period_type%TYPE;

4629: ln_person_id per_all_assignments_f.person_id%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;