APPS.FII_AR_CUSTOMER_DIMENSION_PKG dependencies on FII_AR_PARTIES_LEVEL2_GT

Line 661: g_state := 'Populate FII_AR_Parties_Level2_GT while looping through FII_AR_Parties_Level1_GT.';

657: FII_UTIL.stop_timer;
658: FII_UTIL.print_timer('Duration');
659: end if;
660:
661: g_state := 'Populate FII_AR_Parties_Level2_GT while looping through FII_AR_Parties_Level1_GT.';
662: if g_debug_flag = 'Y' then
663: FII_UTIL.put_line(g_state);
664: FII_UTIL.start_timer;
665: end if;

Line 672: THEN INTO FII_AR_Parties_Level2_GT(

668: LOOP
669:
670: INSERT ALL
671: WHEN (SRLID=1)
672: THEN INTO FII_AR_Parties_Level2_GT(
673: Party_ID)
674: VALUES(Child_ID)
675: WHEN (SRLID=1)
676: THEN INTO FII_AR_Top_To_Source_GT(

Line 707: FII_UTIL.put_line('Completed population of FII_AR_Parties_Level2_GT.');

703:
704: END LOOP;
705:
706: if g_debug_flag = 'Y' then
707: FII_UTIL.put_line('Completed population of FII_AR_Parties_Level2_GT.');
708: FII_UTIL.stop_timer;
709: FII_UTIL.print_timer('Duration');
710: end if;
711:

Line 712: g_state := 'Populate FII_AR_Parties_Delta_GT with descendants of parties in FII_AR_Parties_Level2_GT.';

708: FII_UTIL.stop_timer;
709: FII_UTIL.print_timer('Duration');
710: end if;
711:
712: g_state := 'Populate FII_AR_Parties_Delta_GT with descendants of parties in FII_AR_Parties_Level2_GT.';
713: if g_debug_flag = 'Y' then
714: FII_UTIL.put_line(g_state);
715: FII_UTIL.start_timer;
716: end if;

Line 720: FROM FII_AR_Parties_Level2_GT Log,

716: end if;
717:
718: INSERT INTO FII_AR_Parties_Delta_GT(Party_ID, Type_ID)
719: SELECT HN.Child_ID, 1
720: FROM FII_AR_Parties_Level2_GT Log,
721: HZ_Hierarchy_Nodes HN
722: WHERE Log.Party_ID = HN.Parent_ID
723: AND HN.Hierarchy_Type = g_hierarchy_type
724: AND g_sysdate BETWEEN HN.Effective_Start_Date AND HN.Effective_End_Date;