DBA Data[Home] [Help]

APPS.AP_EMPLOYEE_UPDATE_PKG dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 7: g_business_group_id FINANCIALS_SYSTEM_PARAMETERS.BUSINESS_GROUP_ID%TYPE;

3:
4: -- Performance fix for 115.9 , ARU 2628027
5: -- Add global variable to capture business_group_id
6:
7: g_business_group_id FINANCIALS_SYSTEM_PARAMETERS.BUSINESS_GROUP_ID%TYPE;
8:
9:
10: /* This is a print procedure to split a message string into 132 character
11: strings. */

Line 56: -- Removed reference to FINANCIALS_SYSTEM_PARAMETERS in all the CURSORS below

52: p_debug_mode IN VARCHAR2,
53: p_calling_sequence IN VARCHAR2)
54: RETURN BOOLEAN IS
55: -- ARU 2628027 , change for 115.9 Performance
56: -- Removed reference to FINANCIALS_SYSTEM_PARAMETERS in all the CURSORS below
57: -- to avoid CARTESIAN JOIN. Since join to FINANCIALS_SYSTEM_PARAMETERS was only to
58: -- get the business_group_id , the value is obtained beforehand
59: -- and referenced in each query below as a bind variable
60:

Line 57: -- to avoid CARTESIAN JOIN. Since join to FINANCIALS_SYSTEM_PARAMETERS was only to

53: p_calling_sequence IN VARCHAR2)
54: RETURN BOOLEAN IS
55: -- ARU 2628027 , change for 115.9 Performance
56: -- Removed reference to FINANCIALS_SYSTEM_PARAMETERS in all the CURSORS below
57: -- to avoid CARTESIAN JOIN. Since join to FINANCIALS_SYSTEM_PARAMETERS was only to
58: -- get the business_group_id , the value is obtained beforehand
59: -- and referenced in each query below as a bind variable
60:
61:

Line 238: FROM financials_system_parameters ;

234: -- Get value for g_business_group_id
235:
236: SELECT business_group_id
237: INTO g_business_group_id
238: FROM financials_system_parameters ;
239:
240:
241: if (p_from_supplier is null and p_to_supplier is null) then
242: