APPS.CSTPACDP dependencies on HR_ORGANIZATION_INFORMATION

Line 2519: FROM hr_organization_information

2515: l_stmt_num := 11;
2516:
2517: SELECT to_number(org_information3)
2518: INTO l_org_ou
2519: FROM hr_organization_information
2520: WHERE org_information_context = 'Accounting Information'
2521: AND organization_id = i_txn_org_id;
2522:
2523: l_stmt_num := 12;

Line 2526: FROM hr_organization_information

2522:
2523: l_stmt_num := 12;
2524: SELECT to_number(org_information3)
2525: INTO l_txf_org_ou
2526: FROM hr_organization_information
2527: WHERE org_information_context = 'Accounting Information'
2528: AND organization_id = i_txf_org_id;
2529:
2530: l_io_invoicing := to_number(fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER'));

Line 7369: FROM hr_organization_information

7365: l_stmt_num := 11;
7366:
7367: SELECT to_number(org_information3)
7368: INTO l_org_ou
7369: FROM hr_organization_information
7370: WHERE org_information_context = 'Accounting Information'
7371: AND organization_id = org_id;
7372:
7373: l_stmt_num := 12;

Line 7376: FROM hr_organization_information

7372:
7373: l_stmt_num := 12;
7374: SELECT to_number(org_information3)
7375: INTO l_txf_org_ou
7376: FROM hr_organization_information
7377: WHERE org_information_context = 'Accounting Information'
7378: AND organization_id = txf_org_id;
7379:
7380: l_io_invoicing := to_number(fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER'));