APPS.PAY_NL_PAYSLIP_ARCHIVE dependencies on PAY_ALL_PAYROLLS_F

Line 571: FROM pay_all_payrolls_f ppf

567: CURSOR csr_payrolls (p_payroll_id NUMBER
568: ,p_consolidation_set_id NUMBER
569: ,p_effective_date DATE) IS
570: SELECT ppf.payroll_id
571: FROM pay_all_payrolls_f ppf
572: WHERE ppf.consolidation_set_id = p_consolidation_set_id
573: AND ppf.payroll_id = NVL(p_payroll_id,ppf.payroll_id)
574: AND p_effective_date BETWEEN ppf.effective_start_date
575: AND ppf.effective_end_date;

Line 1504: FROM pay_all_payrolls_f paf

1500: --
1501: CURSOR csr_payroll_period is
1502: SELECT paf.period_type period_type
1503: ,paf.business_group_id bug_group_id
1504: FROM pay_all_payrolls_f paf
1505: WHERE payroll_id = p_payroll_id
1506: AND p_date_earned BETWEEN paf.effective_start_date
1507: AND paf.effective_end_date;
1508: --

Line 1655: l_period_type pay_all_payrolls_f.period_type%TYPE;

1651: l_ni hr_lookups.meaning%TYPE;
1652: l_period hr_lookups.meaning%TYPE;
1653: l_table hr_lookups.meaning%TYPE;
1654: l_age NUMBER;
1655: l_period_type pay_all_payrolls_f.period_type%TYPE;
1656: l_ret pay_user_column_instances_f.value%TYPE;
1657: l_struct_id NUMBER;
1658: l_min_wage_type pay_user_columns.user_column_name%TYPE;
1659: l_min_wage_factor NUMBER;