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 3405: l_uom gl_stat_account_uom.unit_of_measure%TYPE;

3401: l_num_segments NUMBER;
3402: l_account_segment_num NUMBER;
3403: l_result BOOLEAN;
3404: l_segment_delimiter VARCHAR2(1);
3405: l_uom gl_stat_account_uom.unit_of_measure%TYPE;
3406: l_status VARCHAR2(10) := '';
3407: l_industry VARCHAR2(10) := '';
3408:
3409: BEGIN

Line 3456: FROM gl_stat_account_uom

3452: -- Using the segment array and the index: Get the UOM value
3453: --
3454: SELECT unit_of_measure
3455: INTO l_uom
3456: FROM gl_stat_account_uom
3457: WHERE account_segment_value = l_segments(l_account_segment_num)
3458: AND chart_of_accounts_id = X_Ch_Of_Accts_Id;
3459:
3460: RETURN(l_uom);