DBA Data[Home] [Help]

APPS.AP_INVOICE_LINES_PKG dependencies on GL_CODE_COMBINATIONS

Line 94: GL_Code_combinations GL

90: ADSL.attribute14,
91: ADSL.attribute15,
92: ADSL.type_1099
93: FROM AP_Distribution_Set_Lines ADSL,
94: GL_Code_combinations GL
95: WHERE distribution_set_id = X_invoice_lines_rec.Distribution_Set_id
96: AND GL.code_combination_id = ADSL.dist_code_combination_id
97: ORDER BY distribution_set_line_number;
98:

Line 103: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;

99:
100: l_pa_allows_overrides VARCHAR2(1) := 'N';
101: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;
102: user_id NUMBER;
103: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
104: l_dset_line_ccid
105: AP_DISTRIBUTION_SET_LINES.DIST_CODE_COMBINATION_ID%TYPE;
106: l_dset_dist_line_num
107: AP_DISTRIBUTION_SET_LINES.DISTRIBUTION_SET_LINE_NUMBER%TYPE;

Line 565: FROM gl_code_combinations

561: X_dist_tab(i).dist_ccid := X_invoice_lines_rec.default_dist_ccid;
562: BEGIN
563: SELECT account_type
564: INTO l_account_type
565: FROM gl_code_combinations
566: WHERE code_combination_id = X_invoice_lines_rec.default_dist_ccid;
567:
568: EXCEPTION
569: WHEN no_data_found THEN

Line 640: FROM gl_code_combinations

636: debug_info := 'Get account type from overlayed account';
637: BEGIN
638: SELECT account_type
639: INTO l_account_type
640: FROM gl_code_combinations
641: WHERE code_combination_id = l_dset_line_ccid;
642:
643: EXCEPTION
644: WHEN no_data_found then