APPS.CSTPACDP dependencies on HR_ORGANIZATION_INFORMATION

Line 2428: FROM hr_organization_information

2424: l_stmt_num := 11;
2425:
2426: SELECT to_number(org_information3)
2427: INTO l_org_ou
2428: FROM hr_organization_information
2429: WHERE org_information_context = 'Accounting Information'
2430: AND organization_id = i_txn_org_id;
2431:
2432: l_stmt_num := 12;

Line 2435: FROM hr_organization_information

2431:
2432: l_stmt_num := 12;
2433: SELECT to_number(org_information3)
2434: INTO l_txf_org_ou
2435: FROM hr_organization_information
2436: WHERE org_information_context = 'Accounting Information'
2437: AND organization_id = i_txf_org_id;
2438:
2439: l_io_invoicing := to_number(fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER'));

Line 7170: FROM hr_organization_information

7166: l_stmt_num := 11;
7167:
7168: SELECT to_number(org_information3)
7169: INTO l_org_ou
7170: FROM hr_organization_information
7171: WHERE org_information_context = 'Accounting Information'
7172: AND organization_id = org_id;
7173:
7174: l_stmt_num := 12;

Line 7177: FROM hr_organization_information

7173:
7174: l_stmt_num := 12;
7175: SELECT to_number(org_information3)
7176: INTO l_txf_org_ou
7177: FROM hr_organization_information
7178: WHERE org_information_context = 'Accounting Information'
7179: AND organization_id = txf_org_id;
7180:
7181: l_io_invoicing := to_number(fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER'));