APPS.PAY_IE_LEGISLATIVE_ARCHIVE dependencies on HR_SOFT_CODING_KEYFLEX

Line 798: hr_soft_coding_keyflex flex,

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
802: AND org.org_information_context = 'IE_EMPLOYER_INFO'

Line 1659: hr_soft_coding_keyflex flex,

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
1663: AND org.org_information_context = 'IE_EMPLOYER_INFO'

Line 1768: hr_soft_coding_keyflex flex,

1764: ppf.period_type period_type,
1765: pact.pay_advice_message payroll_message
1766: FROM pay_payrolls_f ppf,
1767: pay_payroll_actions pact,
1768: hr_soft_coding_keyflex flex,
1769: hr_organization_information org
1770: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
1771: AND org.org_information_context = 'IE_ORG_INFORMATION'
1772: AND org.org_information1 = flex.segment1

Line 2877: hr_soft_coding_keyflex flex,

2873: ppf.period_type period_type,
2874: pact.pay_advice_message payroll_message
2875: FROM pay_payrolls_f ppf,
2876: pay_payroll_actions pact,
2877: hr_soft_coding_keyflex flex,
2878: hr_organization_information org
2879: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
2880: AND org.org_information_context = 'IE_EMPLOYER_INFO'
2881: AND org.organization_id = flex.segment4