APPS.PAY_IE_LEGISLATIVE_ARCHIVE dependencies on PAY_ALL_PAYROLLS_F

Line 769: FROM pay_all_payrolls_f

765:
766: CURSOR csr_payroll_type(p_payroll_id NUMBER,
767: p_effective_date DATE) IS
768: SELECT period_type
769: FROM pay_all_payrolls_f
770: WHERE payroll_id = p_payroll_id
771: AND p_effective_date
772: BETWEEN effective_start_date AND effective_end_date;
773:

Line 797: pay_all_payrolls_f ppf,

793: )IS
794:
795: SELECT org.organization_id
796: FROM
797: pay_all_payrolls_f ppf,
798: hr_soft_coding_keyflex flex,
799: hr_organization_information org
800: WHERE ppf.soft_coding_keyflex_id=flex.soft_coding_keyflex_id
801: AND ppf.business_group_id =p_business_group_id

Line 1647: pay_all_payrolls_f ppf

1643: is
1644: CURSOR get_payrolls is
1645: SELECT ppf.payroll_id
1646: FROM
1647: pay_all_payrolls_f ppf
1648: WHERE ppf.consolidation_set_id=p_consolidation_set
1649: AND ppf.business_group_id =p_business_group_id
1650: AND ppf.effective_start_date <= p_end_date
1651: AND ppf.effective_end_date >= p_start_date

Line 1658: pay_all_payrolls_f ppf,

1654: --Changed to handle to architecture for Employer
1655: CURSOR get_paye_reference_details(p_payroll_id varchar2) is
1656: SELECT org.org_information2
1657: FROM
1658: pay_all_payrolls_f ppf,
1659: hr_soft_coding_keyflex flex,
1660: hr_organization_information org
1661: WHERE ppf.soft_coding_keyflex_id=flex.soft_coding_keyflex_id
1662: AND ppf.business_group_id =p_business_group_id

Line 1745: FROM pay_all_payrolls_f ppf

1741: CURSOR csr_payrolls (p_payroll_id NUMBER,
1742: p_consolidation_set_id NUMBER,
1743: p_effective_date DATE) IS
1744: SELECT ppf.payroll_id
1745: FROM pay_all_payrolls_f ppf
1746: WHERE ppf.consolidation_set_id = p_consolidation_set_id
1747: AND ppf.payroll_id = NVL(p_payroll_id,ppf.payroll_id)
1748: AND p_effective_date BETWEEN
1749: ppf.effective_start_date AND ppf.effective_end_date;

Line 2852: FROM pay_all_payrolls_f ppf

2848: CURSOR csr_payrolls (p_payroll_id NUMBER,
2849: p_consolidation_set_id NUMBER,
2850: p_effective_date DATE) IS
2851: SELECT ppf.payroll_id
2852: FROM pay_all_payrolls_f ppf
2853: WHERE ppf.consolidation_set_id = p_consolidation_set_id
2854: AND ppf.payroll_id = NVL(p_payroll_id,ppf.payroll_id)
2855: AND p_effective_date BETWEEN
2856: ppf.effective_start_date AND ppf.effective_end_date;