APPS.AP_INVOICE_DISTRIBUTIONS_PKG dependencies on GL_STAT_ACCOUNT_UOM

Line 87: uom gl_stat_account_uom.unit_of_measure%TYPE;

83: RETURN VARCHAR2
84: IS
85: column_name VARCHAR2(20) := '';
86: segment_val gl_code_combinations.SEGMENT1%TYPE;
87: uom gl_stat_account_uom.unit_of_measure%TYPE;
88: status VARCHAR2(10) := '';
89: industry VARCHAR2(10) := '';
90:
91: BEGIN

Line 139: from gl_stat_account_uom

135: where code_combination_id = X_CCID;
136:
137: select unit_of_measure
138: into uom
139: from gl_stat_account_uom
140: where account_segment_value = segment_val
141: and chart_of_accounts_id = X_Ch_Of_Accts_Id ;
142:
143: return(uom);

Line 3236: l_uom gl_stat_account_uom.unit_of_measure%TYPE;

3232: l_num_segments NUMBER;
3233: l_account_segment_num NUMBER;
3234: l_result BOOLEAN;
3235: l_segment_delimiter VARCHAR2(1);
3236: l_uom gl_stat_account_uom.unit_of_measure%TYPE;
3237: l_status VARCHAR2(10) := '';
3238: l_industry VARCHAR2(10) := '';
3239:
3240: BEGIN

Line 3287: FROM gl_stat_account_uom

3283: -- Using the segment array and the index: Get the UOM value
3284: --
3285: SELECT unit_of_measure
3286: INTO l_uom
3287: FROM gl_stat_account_uom
3288: WHERE account_segment_value = l_segments(l_account_segment_num)
3289: AND chart_of_accounts_id = X_Ch_Of_Accts_Id;
3290:
3291: RETURN(l_uom);