DBA Data[Home] [Help]

APPS.HXC_RPT_LOAD_TC_SNAPSHOT dependencies on FND_GLOBAL

Line 36: AND business_group_id = FND_GLOBAL.per_business_group_id

32: FROM per_assignment_status_types
33: WHERE user_status IN ( ''Active Assignment''
34: ,''Active Contingent Assignment'') )
35: AND assignment_type IN (''E'',''C'')
36: AND business_group_id = FND_GLOBAL.per_business_group_id
37: AND ( effective_start_date BETWEEN ''p_date_from''
38: AND ''p_date_to''
39: OR effective_end_date BETWEEN ''p_date_from''
40: AND ''p_date_to''

Line 1663: AND flv.security_group_id = FND_GLOBAL.lookup_security_group(flv.lookup_type,

1659: AND flv.language = userenv('LANG')
1660: AND flv.lookup_type IN ( 'HXC_CHANGE_AUDIT_REASONS',
1661: 'HXC_LATE_AUDIT_REASONS')
1662: AND flv.view_application_id = 3
1663: AND flv.security_group_id = FND_GLOBAL.lookup_security_group(flv.lookup_type,
1664: flv.view_application_id);
1665:
1666: l_meaning_tab VARCHARTABLE;
1667: l_type_tab VARCHARTABLE;

Line 2396: g_request_id := FND_GLOBAL.CONC_PRIORITY_REQUEST;

2392: -- future reference.
2393: -- Clear HXC_RPT_TC_RESOURCE_TEMP, for the next iteration ( next 20 resources ).
2394:
2395: g_request_sysdate := SYSDATE;
2396: g_request_id := FND_GLOBAL.CONC_PRIORITY_REQUEST;
2397:
2398: IF g_debug
2399: THEN
2400: hr_utility.trace('Load Timecard Snapshot ');