APPS.PAY_IE_LEGISLATIVE_ARCHIVE dependencies on PAY_ALL_PAYROLLS_F

Line 958: FROM pay_all_payrolls_f

954:
955: CURSOR csr_payroll_type(p_payroll_id NUMBER,
956: p_effective_date DATE) IS
957: SELECT period_type
958: FROM pay_all_payrolls_f
959: WHERE payroll_id = p_payroll_id
960: AND p_effective_date
961: BETWEEN effective_start_date AND effective_end_date;
962:

Line 986: pay_all_payrolls_f ppf,

982: )IS
983:
984: SELECT org.organization_id
985: FROM
986: pay_all_payrolls_f ppf,
987: hr_soft_coding_keyflex flex,
988: hr_organization_information org
989: WHERE ppf.soft_coding_keyflex_id=flex.soft_coding_keyflex_id
990: AND ppf.business_group_id =p_business_group_id

Line 1934: pay_all_payrolls_f ppf

1930: is
1931: CURSOR get_payrolls is
1932: SELECT ppf.payroll_id
1933: FROM
1934: pay_all_payrolls_f ppf
1935: WHERE ppf.consolidation_set_id=p_consolidation_set
1936: AND ppf.business_group_id =p_business_group_id
1937: AND ppf.effective_start_date <= p_end_date
1938: AND ppf.effective_end_date >= p_start_date

Line 1945: pay_all_payrolls_f ppf,

1941: --Changed to handle to architecture for Employer
1942: CURSOR get_paye_reference_details(p_payroll_id varchar2) is
1943: SELECT org.org_information2
1944: FROM
1945: pay_all_payrolls_f ppf,
1946: hr_soft_coding_keyflex flex,
1947: hr_organization_information org
1948: WHERE ppf.soft_coding_keyflex_id=flex.soft_coding_keyflex_id
1949: AND ppf.business_group_id =p_business_group_id

Line 2032: FROM pay_all_payrolls_f ppf

2028: CURSOR csr_payrolls (p_payroll_id NUMBER,
2029: p_consolidation_set_id NUMBER,
2030: p_effective_date DATE) IS
2031: SELECT ppf.payroll_id
2032: FROM pay_all_payrolls_f ppf
2033: WHERE ppf.consolidation_set_id = p_consolidation_set_id
2034: AND ppf.payroll_id = NVL(p_payroll_id,ppf.payroll_id)
2035: AND p_effective_date BETWEEN
2036: ppf.effective_start_date AND ppf.effective_end_date;

Line 3167: FROM pay_all_payrolls_f ppf

3163: CURSOR csr_payrolls (p_payroll_id NUMBER,
3164: p_consolidation_set_id NUMBER,
3165: p_effective_date DATE) IS
3166: SELECT ppf.payroll_id
3167: FROM pay_all_payrolls_f ppf
3168: WHERE ppf.consolidation_set_id = p_consolidation_set_id
3169: AND ppf.payroll_id = NVL(p_payroll_id,ppf.payroll_id)
3170: AND p_effective_date BETWEEN
3171: ppf.effective_start_date AND ppf.effective_end_date;