DBA Data[Home] [Help]

APPS.JA_CN_CFS_CLT_SLA_PKG dependencies on JA_CN_CFS_ITEM_MAPPING_HDRS

Line 525: l_event_class_code ja_cn_cfs_item_mapping_hdrs.event_class_code%TYPE;

521: -- the interim variables for activities all table
522: l_line_org_id xla_transaction_entities.security_id_int_1%TYPE;
523: l_mapping_org_id NUMBER;
524: l_detailed_cfs_item ja_cn_cfs_activities_all.detailed_cfs_item%type;
525: l_event_class_code ja_cn_cfs_item_mapping_hdrs.event_class_code%TYPE;
526:
527: --the analytical criterion variables
528: l_analytical_criterion_code xla_ae_line_acs.analytical_criterion_code%type;
529: l_ac_type_code xla_ae_line_acs.analytical_criterion_type_code%type;

Line 915: From ja_cn_cfs_item_mapping_hdrs jcch,

911: --in the mapping table
912: BEGIN
913: Select jccl.detailed_cfs_item, jccl.org_id, jcch.event_class_code
914: Into l_detailed_cfs_item, L_mapping_org_id, l_event_class_code
915: From ja_cn_cfs_item_mapping_hdrs jcch,
916: ja_cn_cfs_item_mapping_lines jccl
917: Where jcch.Chart_of_Accounts_id = p_coa_id
918: And jcch.analytical_criterion_code = l_analytical_criterion_code
919: AND jcch.analytical_criterion_type_code = l_ac_type_code

Line 944: From ja_cn_cfs_item_mapping_hdrs jcch,

940:
941: BEGIN
942: Select jccl.detailed_cfs_item,jcch.event_class_code
943: Into l_detailed_cfs_item,l_event_class_code
944: From ja_cn_cfs_item_mapping_hdrs jcch,
945: ja_cn_cfs_item_mapping_lines jccl
946: Where jcch.Chart_of_Accounts_id = p_coa_id
947: And jcch.analytical_criterion_code = l_analytical_criterion_code
948: AND jcch.analytical_criterion_type_code = l_ac_type_code