APPS.JAI_GST_TAX_DEFAULTATION_PKG dependencies on OE_SYSTEM_PARAMETERS

Line 39: SELECT master_organization_id FROM oe_system_parameters;

35: pn_location_id IN NUMBER)
36: RETURN VARCHAR2 IS
37:
38: CURSOR cur_get_master_org_id IS
39: SELECT master_organization_id FROM oe_system_parameters;
40:
41: CURSOR cur_state(pn_organization_id IN NUMBER) IS
42: SELECT jrp.state_code state_code
43: FROM JAI_RGM_PARTIES jrp, JAI_RGM_DEFINITIONS jrd

Line 711: FROM oe_system_parameters;

707: v_operating_unit NUMBER;
708:
709: CURSOR cur_get_master_org_id IS
710: SELECT org_id operating_unit, master_organization_id
711: FROM oe_system_parameters;
712:
713: CURSOR operating_unit_cur(c_org_id NUMBER) IS
714: SELECT operating_unit
715: FROM org_organization_definitions