DBA Data[Home] [Help]

APPS.AP_INVOICE_LINES_PKG dependencies on GL_CODE_COMBINATIONS

Line 80: GL_Code_combinations GL

76: ADSL.attribute14,
77: ADSL.attribute15,
78: ADSL.type_1099
79: FROM AP_Distribution_Set_Lines ADSL,
80: GL_Code_combinations GL
81: WHERE distribution_set_id = X_invoice_lines_rec.Distribution_Set_id
82: AND GL.code_combination_id = ADSL.dist_code_combination_id
83: ORDER BY distribution_set_line_number;
84:

Line 89: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;

85:
86: l_pa_allows_overrides VARCHAR2(1) := 'N';
87: l_employee_id AP_SUPPLIERS.EMPLOYEE_ID%TYPE;
88: user_id NUMBER;
89: l_account_type GL_CODE_COMBINATIONS.ACCOUNT_TYPE%TYPE;
90: l_dset_line_ccid
91: AP_DISTRIBUTION_SET_LINES.DIST_CODE_COMBINATION_ID%TYPE;
92: l_dset_dist_line_num
93: AP_DISTRIBUTION_SET_LINES.DISTRIBUTION_SET_LINE_NUMBER%TYPE;

Line 530: FROM gl_code_combinations

526: X_dist_tab(i).dist_ccid := X_invoice_lines_rec.default_dist_ccid;
527: BEGIN
528: SELECT account_type
529: INTO l_account_type
530: FROM gl_code_combinations
531: WHERE code_combination_id = X_invoice_lines_rec.default_dist_ccid;
532:
533: EXCEPTION
534: WHEN no_data_found THEN

Line 605: FROM gl_code_combinations

601: debug_info := 'Get account type from overlayed account';
602: BEGIN
603: SELECT account_type
604: INTO l_account_type
605: FROM gl_code_combinations
606: WHERE code_combination_id = l_dset_line_ccid;
607:
608: EXCEPTION
609: WHEN no_data_found then