DBA Data[Home] [Help]

VIEW: APPS.HRDPV_DELETE_BENEFITS_GROUP

Source

View Text - Preformatted

select batch_id            batch_id
,      batch_line_id       batch_line_id
,      api_module_id       api_module_id
,      line_status         line_status
,      user_sequence       user_sequence
,      link_value          link_value
,      business_group_name business_group_name,
       pval001 P_BENEFITS_GROUP
from hr_pump_batch_lines
where api_module_id = 106
with check option 
View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, BATCH_LINE_ID BATCH_LINE_ID
, API_MODULE_ID API_MODULE_ID
, LINE_STATUS LINE_STATUS
, USER_SEQUENCE USER_SEQUENCE
, LINK_VALUE LINK_VALUE
, BUSINESS_GROUP_NAME BUSINESS_GROUP_NAME
, PVAL001 P_BENEFITS_GROUP FROM HR_PUMP_BATCH_LINES WHERE API_MODULE_ID = 106 WITH CHECK OPTION