APPS.PAY_FR_PAY_FILE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 21: estab_id hr_all_organization_units.ORGANIZATION_ID%TYPE,

17: */
18: -- private globals for caching used by get_payers_id and valid_org
19:
20: TYPE g_estab_rec IS RECORD (
21: estab_id hr_all_organization_units.ORGANIZATION_ID%TYPE,
22: company_id hr_all_organization_units.ORGANIZATION_ID%TYPE);
23: TYPE g_estab_typ IS TABLE OF g_estab_rec Index by BINARY_INTEGER;
24: g_estab_tbl g_estab_typ;
25: --

Line 22: company_id hr_all_organization_units.ORGANIZATION_ID%TYPE);

18: -- private globals for caching used by get_payers_id and valid_org
19:
20: TYPE g_estab_rec IS RECORD (
21: estab_id hr_all_organization_units.ORGANIZATION_ID%TYPE,
22: company_id hr_all_organization_units.ORGANIZATION_ID%TYPE);
23: TYPE g_estab_typ IS TABLE OF g_estab_rec Index by BINARY_INTEGER;
24: g_estab_tbl g_estab_typ;
25: --
26: g_org_id hr_all_organization_units.organization_id%TYPE;

Line 26: g_org_id hr_all_organization_units.organization_id%TYPE;

22: company_id hr_all_organization_units.ORGANIZATION_ID%TYPE);
23: TYPE g_estab_typ IS TABLE OF g_estab_rec Index by BINARY_INTEGER;
24: g_estab_tbl g_estab_typ;
25: --
26: g_org_id hr_all_organization_units.organization_id%TYPE;
27: g_org_class hr_organization_information.org_information1%TYPE;
28:
29: -- end of private globals for caching used by get_payers_id and valid_org
30:

Line 54: hr_all_organization_units org

50: L_payers_id
51: From hr_organization_information ori_opm,
52: hr_organization_information ori_class,
53: hr_organization_information ori_info,
54: hr_all_organization_units org
55: Where ori_opm.org_information1 = L_opm_id_chr
56: And ori_opm.org_information_context = 'FR_DYN_PAYMETH_MAPPING_INFO'
57: And ori_class.organization_id = ori_opm.organization_id
58: And ori_class.org_information_context = 'CLASS'