DBA Data[Home] [Help]

APPS.JA_CN_CFS_DATA_CLT_PKG dependencies on GL_JE_HEADERS

Line 663: l_je_header_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;

659: l_period_name_to gl_periods.period_name%TYPE:=P_GL_PERIOD_TO; --period name of th
660:
661: -- GL: GL_JE_HEADER
662: l_je_func_curr_code gl_sets_of_books.currency_code%TYPE;
663: l_je_header_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;
664: l_je_catg GL_JE_HEADERS.je_category%TYPE;
665: l_je_jnl_name GL_JE_HEADERS.name%TYPE;
666: l_je_jnl_doc_seq_num GL_JE_HEADERS.Doc_Sequence_Value%TYPE;
667: l_je_curr_code GL_JE_HEADERS.currency_code%TYPE;

Line 664: l_je_catg GL_JE_HEADERS.je_category%TYPE;

660:
661: -- GL: GL_JE_HEADER
662: l_je_func_curr_code gl_sets_of_books.currency_code%TYPE;
663: l_je_header_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;
664: l_je_catg GL_JE_HEADERS.je_category%TYPE;
665: l_je_jnl_name GL_JE_HEADERS.name%TYPE;
666: l_je_jnl_doc_seq_num GL_JE_HEADERS.Doc_Sequence_Value%TYPE;
667: l_je_curr_code GL_JE_HEADERS.currency_code%TYPE;
668: l_je_curr_cov_rate GL_JE_HEADERS.currency_conversion_rate%TYPE;

Line 665: l_je_jnl_name GL_JE_HEADERS.name%TYPE;

661: -- GL: GL_JE_HEADER
662: l_je_func_curr_code gl_sets_of_books.currency_code%TYPE;
663: l_je_header_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;
664: l_je_catg GL_JE_HEADERS.je_category%TYPE;
665: l_je_jnl_name GL_JE_HEADERS.name%TYPE;
666: l_je_jnl_doc_seq_num GL_JE_HEADERS.Doc_Sequence_Value%TYPE;
667: l_je_curr_code GL_JE_HEADERS.currency_code%TYPE;
668: l_je_curr_cov_rate GL_JE_HEADERS.currency_conversion_rate%TYPE;
669: l_je_curr_cov_type GL_JE_HEADERS.currency_conversion_type%TYPE;

Line 666: l_je_jnl_doc_seq_num GL_JE_HEADERS.Doc_Sequence_Value%TYPE;

662: l_je_func_curr_code gl_sets_of_books.currency_code%TYPE;
663: l_je_header_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;
664: l_je_catg GL_JE_HEADERS.je_category%TYPE;
665: l_je_jnl_name GL_JE_HEADERS.name%TYPE;
666: l_je_jnl_doc_seq_num GL_JE_HEADERS.Doc_Sequence_Value%TYPE;
667: l_je_curr_code GL_JE_HEADERS.currency_code%TYPE;
668: l_je_curr_cov_rate GL_JE_HEADERS.currency_conversion_rate%TYPE;
669: l_je_curr_cov_type GL_JE_HEADERS.currency_conversion_type%TYPE;
670: l_je_curr_cov_date GL_JE_HEADERS.currency_conversion_date%TYPE;

Line 667: l_je_curr_code GL_JE_HEADERS.currency_code%TYPE;

663: l_je_header_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;
664: l_je_catg GL_JE_HEADERS.je_category%TYPE;
665: l_je_jnl_name GL_JE_HEADERS.name%TYPE;
666: l_je_jnl_doc_seq_num GL_JE_HEADERS.Doc_Sequence_Value%TYPE;
667: l_je_curr_code GL_JE_HEADERS.currency_code%TYPE;
668: l_je_curr_cov_rate GL_JE_HEADERS.currency_conversion_rate%TYPE;
669: l_je_curr_cov_type GL_JE_HEADERS.currency_conversion_type%TYPE;
670: l_je_curr_cov_date GL_JE_HEADERS.currency_conversion_date%TYPE;
671: l_je_inter_flag GL_JE_HEADERS.global_attribute1%TYPE;

Line 668: l_je_curr_cov_rate GL_JE_HEADERS.currency_conversion_rate%TYPE;

664: l_je_catg GL_JE_HEADERS.je_category%TYPE;
665: l_je_jnl_name GL_JE_HEADERS.name%TYPE;
666: l_je_jnl_doc_seq_num GL_JE_HEADERS.Doc_Sequence_Value%TYPE;
667: l_je_curr_code GL_JE_HEADERS.currency_code%TYPE;
668: l_je_curr_cov_rate GL_JE_HEADERS.currency_conversion_rate%TYPE;
669: l_je_curr_cov_type GL_JE_HEADERS.currency_conversion_type%TYPE;
670: l_je_curr_cov_date GL_JE_HEADERS.currency_conversion_date%TYPE;
671: l_je_inter_flag GL_JE_HEADERS.global_attribute1%TYPE;
672: l_je_effective_date GL_JE_HEADERS.DEFAULT_EFFECTIVE_DATE%TYPE;

Line 669: l_je_curr_cov_type GL_JE_HEADERS.currency_conversion_type%TYPE;

665: l_je_jnl_name GL_JE_HEADERS.name%TYPE;
666: l_je_jnl_doc_seq_num GL_JE_HEADERS.Doc_Sequence_Value%TYPE;
667: l_je_curr_code GL_JE_HEADERS.currency_code%TYPE;
668: l_je_curr_cov_rate GL_JE_HEADERS.currency_conversion_rate%TYPE;
669: l_je_curr_cov_type GL_JE_HEADERS.currency_conversion_type%TYPE;
670: l_je_curr_cov_date GL_JE_HEADERS.currency_conversion_date%TYPE;
671: l_je_inter_flag GL_JE_HEADERS.global_attribute1%TYPE;
672: l_je_effective_date GL_JE_HEADERS.DEFAULT_EFFECTIVE_DATE%TYPE;
673: l_je_line_num GL_JE_LINES.je_line_num%TYPE;

Line 670: l_je_curr_cov_date GL_JE_HEADERS.currency_conversion_date%TYPE;

666: l_je_jnl_doc_seq_num GL_JE_HEADERS.Doc_Sequence_Value%TYPE;
667: l_je_curr_code GL_JE_HEADERS.currency_code%TYPE;
668: l_je_curr_cov_rate GL_JE_HEADERS.currency_conversion_rate%TYPE;
669: l_je_curr_cov_type GL_JE_HEADERS.currency_conversion_type%TYPE;
670: l_je_curr_cov_date GL_JE_HEADERS.currency_conversion_date%TYPE;
671: l_je_inter_flag GL_JE_HEADERS.global_attribute1%TYPE;
672: l_je_effective_date GL_JE_HEADERS.DEFAULT_EFFECTIVE_DATE%TYPE;
673: l_je_line_num GL_JE_LINES.je_line_num%TYPE;
674: l_je_line_desc GL_JE_LINES.description%TYPE;

Line 671: l_je_inter_flag GL_JE_HEADERS.global_attribute1%TYPE;

667: l_je_curr_code GL_JE_HEADERS.currency_code%TYPE;
668: l_je_curr_cov_rate GL_JE_HEADERS.currency_conversion_rate%TYPE;
669: l_je_curr_cov_type GL_JE_HEADERS.currency_conversion_type%TYPE;
670: l_je_curr_cov_date GL_JE_HEADERS.currency_conversion_date%TYPE;
671: l_je_inter_flag GL_JE_HEADERS.global_attribute1%TYPE;
672: l_je_effective_date GL_JE_HEADERS.DEFAULT_EFFECTIVE_DATE%TYPE;
673: l_je_line_num GL_JE_LINES.je_line_num%TYPE;
674: l_je_line_desc GL_JE_LINES.description%TYPE;
675: l_je_line_amount NUMBER;

Line 672: l_je_effective_date GL_JE_HEADERS.DEFAULT_EFFECTIVE_DATE%TYPE;

668: l_je_curr_cov_rate GL_JE_HEADERS.currency_conversion_rate%TYPE;
669: l_je_curr_cov_type GL_JE_HEADERS.currency_conversion_type%TYPE;
670: l_je_curr_cov_date GL_JE_HEADERS.currency_conversion_date%TYPE;
671: l_je_inter_flag GL_JE_HEADERS.global_attribute1%TYPE;
672: l_je_effective_date GL_JE_HEADERS.DEFAULT_EFFECTIVE_DATE%TYPE;
673: l_je_line_num GL_JE_LINES.je_line_num%TYPE;
674: l_je_line_desc GL_JE_LINES.description%TYPE;
675: l_je_line_amount NUMBER;
676: l_je_line_func_amount NUMBER;

Line 773: FROM GL_JE_HEADERS jeh

769: ,decode(jeh.global_attribute_category, 'JE.CN.GLXJEENT.HEADER',
770: nvl(jeh.global_attribute1, 'N'), 'N'
771: ) inter_flag
772: ,jeh.DEFAULT_EFFECTIVE_DATE effective_date
773: FROM GL_JE_HEADERS jeh
774: ,gl_je_categories_tl jec
775: ,JA_CN_DFF_ASSIGNMENTS DFF
776: WHERE jeh.ledger_id = l_ledger_id --using variable P_LEDGER_ID
777: AND jeh.period_name = l_period_name --using variable l_period_name

Line 821: ,GL_JE_HEADERS jeh

817: nvl(jel.ENTERED_CR, 0) je_entered_amount
818: ,nvl(jel.ACCOUNTED_DR, 0) -
819: nvl(jel.ACCOUNTED_CR, 0) je_accounted_amount
820: FROM GL_JE_LINES jel
821: ,GL_JE_HEADERS jeh
822: ,ja_cn_dff_assignments dffa
823: WHERE jel.je_header_id = l_je_header_id --using variable l_je_header_id
824: AND jeh.je_header_id = jel.je_header_id
825: -- to locate cash flow item in dff_assignment