APPS.IGC_ETAX_UTIL_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 27: G_ORG_LOC_ID HR_ALL_ORGANIZATION_UNITS.location_id%TYPE;

23: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
24: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
25: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
26: G_MODULE_NAME CONSTANT VARCHAR2(64) := 'IGC.PLSQL.ICETXUB.IGC_ETAX_UTIL_PKG.';
27: G_ORG_LOC_ID HR_ALL_ORGANIZATION_UNITS.location_id%TYPE;
28:
29: FUNCTION Populate_Dist_GT(
30: P_CC_Header_Rec IN igc_cc_headers%ROWTYPE,
31: P_Line_Id IN igc_cc_acct_lines.cc_acct_line_id%type,

Line 114: l_rounding_bill_to_party_id HR_ALL_ORGANIZATION_UNITS.organization_id%Type;

110: l_calling_sequence VARCHAR2(240);
111: l_return_status VARCHAR2(32) := FND_API.G_RET_STS_UNEXP_ERROR;
112: l_api_name VARCHAR2(30) := 'Populate_Headers_gt';
113: l_debug_info VARCHAR2(240);
114: l_rounding_bill_to_party_id HR_ALL_ORGANIZATION_UNITS.organization_id%Type;
115: l_ledger_currency fnd_currencies.currency_code%type;
116:
117: BEGIN
118:

Line 721: FROM HR_ALL_ORGANIZATION_UNITS

717: AND P_CC_Header_Rec.location_id IS NULL THEN
718: BEGIN
719: SELECT location_id
720: INTO G_ORG_LOC_ID
721: FROM HR_ALL_ORGANIZATION_UNITS
722: WHERE organization_id = p_cc_header_rec.org_id;
723: EXCEPTION
724: WHEN NO_DATA_FOUND THEN
725: NULL;