APPS.JA_CN_AP_PBD_EXPORT_PKG dependencies on JA_CN_DFF_ASSIGNMENTS

Line 1282: lv_attribute_column4bal_side ja_cn_dff_assignments.attribute_column%TYPE;

1278: lv_dr_cr_code VARCHAR2(10);
1279: lv_debit VARCHAR2(25);
1280: lv_credit VARCHAR2(25);
1281: lv_balance_side VARCHAR2(25);
1282: lv_attribute_column4bal_side ja_cn_dff_assignments.attribute_column%TYPE;
1283: lv_procedure_name VARCHAR2(40) := 'Get_Balance_Side';
1284: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1285: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
1286:

Line 1402: FROM ja_cn_dff_assignments

1398:
1399: --Cursor for getting the Attribute Column for storing Balance Side
1400: CURSOR dff_assignments_cur IS
1401: SELECT attribute_column
1402: FROM ja_cn_dff_assignments
1403: WHERE chart_of_accounts_id = pn_coa_id --parameter: pn_coa_id
1404: AND dff_title_code = 'ACBS';
1405:
1406: BEGIN

Line 1505: lv_attribute_column4bill_num ja_cn_dff_assignments.attribute_column%TYPE;

1501: pn_check_id IN NUMBER) --Updated for fixing bug# 9793920
1502: RETURN VARCHAR2 IS
1503: lv_bill_num VARCHAR(50) := NULL;
1504: lv_context_code VARCHAR(255) := NULL;
1505: lv_attribute_column4bill_num ja_cn_dff_assignments.attribute_column%TYPE;
1506: lv_cursor_sql VARCHAR(200);
1507: TYPE ref_cursor is REF CURSOR;
1508: v_bill_num_row ref_cursor;
1509: lv_procedure_name VARCHAR2(40) := 'Get_Remittance_Bill_Number';

Line 1516: FROM ja_cn_dff_assignments

1512:
1513: --Cursor for getting the Attribute Column for storing Remittance Bill Number
1514: CURSOR dff_assignments_cur IS
1515: SELECT attribute_column, context_code
1516: FROM ja_cn_dff_assignments
1517: WHERE chart_of_accounts_id = pn_coa_id --parameter: pn_coa_id
1518: AND dff_title_code = 'APIN';
1519:
1520: BEGIN