APPS.PAY_IE_LEGISLATIVE_ARCHIVE dependencies on HR_SOFT_CODING_KEYFLEX

Line 987: hr_soft_coding_keyflex flex,

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

Line 1946: hr_soft_coding_keyflex flex,

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

Line 2055: hr_soft_coding_keyflex flex,

2051: ppf.period_type period_type,
2052: pact.pay_advice_message payroll_message
2053: FROM pay_payrolls_f ppf,
2054: pay_payroll_actions pact,
2055: hr_soft_coding_keyflex flex,
2056: hr_organization_information org
2057: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
2058: AND org.org_information_context = 'IE_ORG_INFORMATION'
2059: AND org.org_information1 = flex.segment1

Line 3192: hr_soft_coding_keyflex flex,

3188: ppf.period_type period_type,
3189: pact.pay_advice_message payroll_message
3190: FROM pay_payrolls_f ppf,
3191: pay_payroll_actions pact,
3192: hr_soft_coding_keyflex flex,
3193: hr_organization_information org
3194: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
3195: AND org.org_information_context = 'IE_EMPLOYER_INFO'
3196: AND org.organization_id = flex.segment4