DBA Data[Home] [Help]

APPS.HXC_ELP_UTILS dependencies on HR_GENERAL

Line 433: AND P_TIME_BUILDING_BLOCKS (l_index_det).DATE_TO = fnd_date.date_to_canonical(hr_general.end_of_time)

429: AND P_TIME_BUILDING_BLOCKS (l_index_det).parent_building_block_id =
430: P_TIME_BUILDING_BLOCKS (l_index_day).time_building_block_id
431: AND P_TIME_BUILDING_BLOCKS (l_index_det).parent_building_block_ovn =
432: P_TIME_BUILDING_BLOCKS (l_index_day).object_version_number
433: AND P_TIME_BUILDING_BLOCKS (l_index_det).DATE_TO = fnd_date.date_to_canonical(hr_general.end_of_time)
434: AND P_TIME_BUILDING_BLOCKS (l_index_det).OBJECT_VERSION_NUMBER <> -9999
435: )
436: THEN
437:

Line 1093: ,fnd_date.date_to_canonical(hr_general.end_of_time)

1089: ,P_TIME_BUILDING_BLOCKS (l_index_det).RESOURCE_ID
1090: ,P_TIME_BUILDING_BLOCKS (l_index_det).RESOURCE_TYPE
1091: ,P_TIME_BUILDING_BLOCKS (l_index_det).APPROVAL_STYLE_ID
1092: ,P_TIME_BUILDING_BLOCKS (l_index_det).DATE_FROM
1093: ,fnd_date.date_to_canonical(hr_general.end_of_time)
1094: ,P_TIME_BUILDING_BLOCKS (l_index_det).COMMENT_TEXT
1095: ,P_TIME_BUILDING_BLOCKS (l_index_det).PARENT_BUILDING_BLOCK_OVN
1096: ,'Y'
1097: ,'N'

Line 1121: ,fnd_date.date_to_canonical(hr_general.end_of_time)

1117: ,P_TIME_BUILDING_BLOCKS (l_index_det).RESOURCE_ID
1118: ,P_TIME_BUILDING_BLOCKS (l_index_det).RESOURCE_TYPE
1119: ,P_TIME_BUILDING_BLOCKS (l_index_det).APPROVAL_STYLE_ID
1120: ,P_TIME_BUILDING_BLOCKS (l_index_det).DATE_FROM
1121: ,fnd_date.date_to_canonical(hr_general.end_of_time)
1122: ,P_TIME_BUILDING_BLOCKS (l_index_det).COMMENT_TEXT
1123: ,P_TIME_BUILDING_BLOCKS (l_index_det).PARENT_BUILDING_BLOCK_OVN
1124: ,'Y'
1125: ,'N'