APPS.HR_NL_EXTRA_ASG_RULES dependencies on PAY_PAYROLLS_F

Line 35: l_period_type pay_payrolls_f.period_type%TYPE;

31: ,p_tax_red_apply IN VARCHAR2
32: ,p_labour_tax_apply IN VARCHAR2
33: ,p_add_sr_tax_apply IN VARCHAR2) IS
34: --
35: l_period_type pay_payrolls_f.period_type%TYPE;
36: l_period_code number;
37: p_period_type VARCHAR2(80);
38: l_1_digit VARCHAR2(1);
39: l_2_digit VARCHAR2(1);

Line 54: FROM pay_payrolls_f pp

50: --
51: CURSOR get_payroll_period_type(p_payroll_id NUMBER
52: ,p_effective_date DATE) IS
53: SELECT pp.period_type
54: FROM pay_payrolls_f pp
55: WHERE pp.payroll_id=p_payroll_id
56: AND p_effective_date BETWEEN pp.effective_start_date
57: AND pp.effective_end_date;
58: --

Line 671: FROM pay_payrolls_f ppf

667:
668: CURSOR csr_get_payroll_employer(p_payroll_id NUMBER
669: ,p_effective_date DATE) IS
670: SELECT prl_information1 employer
671: FROM pay_payrolls_f ppf
672: WHERE ppf.payroll_id = p_payroll_id
673: AND p_effective_date BETWEEN ppf.effective_start_date
674: AND ppf.effective_end_date;
675: