APPS.FII_AR_CUSTOMER_DIMENSION_PKG dependencies on DUAL

Line 169: = (SELECT l_max_batch_party_id, sysdate, g_fii_login_id, g_fii_user_id FROM DUAL)

165: FROM HZ_Merge_Party_History;
166:
167: UPDATE FII_Change_Log
168: SET (Item_Value, Last_Update_Date, Last_Update_Login, Last_Updated_By)
169: = (SELECT l_max_batch_party_id, sysdate, g_fii_login_id, g_fii_user_id FROM DUAL)
170: WHERE log_item = 'MAX_BATCH_PARTY_ID';
171:
172: IF SQL%ROWCOUNT = 0 THEN
173: INSERT INTO FII_Change_Log (Log_Item, Item_Value, Creation_Date, Created_By, Last_Update_Date, Last_Update_Login, Last_Updated_By)

Line 272: (SELECT 1 ID FROM Dual UNION

268: g_fii_user_id,
269: g_fii_login_id
270: FROM FII_AR_Cust_Rlns_GT PTN,
271: HZ_Hierarchy_Nodes HN,
272: (SELECT 1 ID FROM Dual UNION
273: SELECT 2 ID FROM Dual) Temp,
274: FII_AR_Cust_LNodes_GT Leaf
275: WHERE PTN.Next_ID = HN.Parent_ID
276: AND (Temp.ID = 1 OR HN.Parent_ID = HN.Child_ID)

Line 273: SELECT 2 ID FROM Dual) Temp,

269: g_fii_login_id
270: FROM FII_AR_Cust_Rlns_GT PTN,
271: HZ_Hierarchy_Nodes HN,
272: (SELECT 1 ID FROM Dual UNION
273: SELECT 2 ID FROM Dual) Temp,
274: FII_AR_Cust_LNodes_GT Leaf
275: WHERE PTN.Next_ID = HN.Parent_ID
276: AND (Temp.ID = 1 OR HN.Parent_ID = HN.Child_ID)
277: AND HN.Hierarchy_Type = g_hierarchy_type

Line 300: = (SELECT l_max_cust_account_id, sysdate, g_fii_login_id, g_fii_user_id FROM DUAL)

296: FROM HZ_Cust_Accounts;
297:
298: UPDATE FII_Change_Log
299: SET (Item_Value, Last_Update_Date, Last_Update_Login, Last_Updated_By)
300: = (SELECT l_max_cust_account_id, sysdate, g_fii_login_id, g_fii_user_id FROM DUAL)
301: WHERE log_item = 'MAX_CUST_ACCOUNT_ID';
302:
303: IF SQL%ROWCOUNT = 0 THEN
304: INSERT INTO FII_Change_Log (Log_Item, Item_Value, Creation_Date, Created_By, Last_Update_Date, Last_Update_Login, Last_Updated_By)

Line 580: = (SELECT l_max_batch_party_id, sysdate, g_fii_login_id, g_fii_user_id FROM DUAL)

576: IF l_max_batch_party_id > l_prev_max_batch_party_id THEN
577:
578: UPDATE FII_Change_Log
579: SET (Item_Value, Last_Update_Date, Last_Update_Login, Last_Updated_By)
580: = (SELECT l_max_batch_party_id, sysdate, g_fii_login_id, g_fii_user_id FROM DUAL)
581: WHERE log_item = 'MAX_BATCH_PARTY_ID';
582:
583: g_state := 'Populate FII_AR_Parties_Delta_GT with parties that have been merged.';
584: if g_debug_flag = 'Y' then

Line 849: (SELECT 1 ID FROM Dual UNION

845: ELSE 0 END Parent_To_Next_Level,
846: HN.Level_Number Next_To_Child_Level
847: FROM FII_AR_Cust_Rlns_GT PTN,
848: HZ_Hierarchy_Nodes HN,
849: (SELECT 1 ID FROM Dual UNION
850: SELECT 2 ID FROM Dual) Temp,
851: FII_AR_Cust_LNodes_GT Leaf
852: WHERE PTN.Next_ID = HN.Parent_ID
853: AND (Temp.ID = 1 OR HN.Parent_ID = HN.Child_ID)

Line 850: SELECT 2 ID FROM Dual) Temp,

846: HN.Level_Number Next_To_Child_Level
847: FROM FII_AR_Cust_Rlns_GT PTN,
848: HZ_Hierarchy_Nodes HN,
849: (SELECT 1 ID FROM Dual UNION
850: SELECT 2 ID FROM Dual) Temp,
851: FII_AR_Cust_LNodes_GT Leaf
852: WHERE PTN.Next_ID = HN.Parent_ID
853: AND (Temp.ID = 1 OR HN.Parent_ID = HN.Child_ID)
854: AND HN.Hierarchy_Type = g_hierarchy_type

Line 887: = (SELECT NVL(l_max_cust_account_id, l_prev_max_cust_account_id), sysdate, g_fii_login_id, g_fii_user_id FROM DUAL)

883: WHERE Cust_Account_ID >= l_prev_max_cust_account_id;
884:
885: UPDATE FII_Change_Log
886: SET (Item_Value, Last_Update_Date, Last_Update_Login, Last_Updated_By)
887: = (SELECT NVL(l_max_cust_account_id, l_prev_max_cust_account_id), sysdate, g_fii_login_id, g_fii_user_id FROM DUAL)
888: WHERE log_item = 'MAX_CUST_ACCOUNT_ID';
889:
890: g_state := 'Populate FII_AR_CAccts_Delta_GT with customer accounts that are new or in an updated hierarchy.';
891: if g_debug_flag = 'Y' then