100: REFERENCE4, -- Header Name
101: REFERENCE5, -- Header Description
102: REFERENCE6, -- Header Reference
103: REFERENCE10, -- Line Description
104: REFERENCE21, -- GL_JE_LINES.reference_1
105: REFERENCE22, -- GL_JE_LINES.reference_2
106: STAT_AMOUNT,
107: SUBLEDGER_DOC_SEQUENCE_ID,
108: SUBLEDGER_DOC_SEQUENCE_VALUE,
101: REFERENCE5, -- Header Description
102: REFERENCE6, -- Header Reference
103: REFERENCE10, -- Line Description
104: REFERENCE21, -- GL_JE_LINES.reference_1
105: REFERENCE22, -- GL_JE_LINES.reference_2
106: STAT_AMOUNT,
107: SUBLEDGER_DOC_SEQUENCE_ID,
108: SUBLEDGER_DOC_SEQUENCE_VALUE,
109: ATTRIBUTE1,
311: REFERENCE4, -- Header Name
312: REFERENCE5, -- Header Description
313: REFERENCE6, -- Header Reference
314: REFERENCE10, -- Line Description
315: REFERENCE21, -- GL_JE_LINES.reference_1
316: REFERENCE22, -- GL_JE_LINES.reference_2
317: STAT_AMOUNT,
318: SUBLEDGER_DOC_SEQUENCE_ID,
319: SUBLEDGER_DOC_SEQUENCE_VALUE,
312: REFERENCE5, -- Header Description
313: REFERENCE6, -- Header Reference
314: REFERENCE10, -- Line Description
315: REFERENCE21, -- GL_JE_LINES.reference_1
316: REFERENCE22, -- GL_JE_LINES.reference_2
317: STAT_AMOUNT,
318: SUBLEDGER_DOC_SEQUENCE_ID,
319: SUBLEDGER_DOC_SEQUENCE_VALUE,
320: ATTRIBUTE1,
689: rule_line_id RULE_LINE_ID
690: FROM jg_zz_ta_rule_lines
691: WHERE account_range_id = JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.account_range_id;
692:
693: l_accted_credit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
694: l_accted_debit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
695: l_entered_credit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
696: l_entered_debit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
697: l_cc_range_code VARCHAR2(100) := NULL;
690: FROM jg_zz_ta_rule_lines
691: WHERE account_range_id = JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.account_range_id;
692:
693: l_accted_credit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
694: l_accted_debit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
695: l_entered_credit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
696: l_entered_debit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
697: l_cc_range_code VARCHAR2(100) := NULL;
698: l_first_alloc_for_jrnal NUMBER;
691: WHERE account_range_id = JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.account_range_id;
692:
693: l_accted_credit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
694: l_accted_debit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
695: l_entered_credit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
696: l_entered_debit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
697: l_cc_range_code VARCHAR2(100) := NULL;
698: l_first_alloc_for_jrnal NUMBER;
699: l_max_prc_alloc_for_jrnal NUMBER := 0;
692:
693: l_accted_credit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
694: l_accted_debit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
695: l_entered_credit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
696: l_entered_debit_amount GL_JE_LINES.entered_dr%TYPE:= 0;
697: l_cc_range_code VARCHAR2(100) := NULL;
698: l_first_alloc_for_jrnal NUMBER;
699: l_max_prc_alloc_for_jrnal NUMBER := 0;
700: l_is_max_prc_alloc_line BOOLEAN := FALSE;