DBA Data[Home] [Help]

VIEW: APPS.HRDPV_FINAL_PROCESS_EMP

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_FINAL_PROCESS_DATE,
       pval002 P_ORG_NOW_NO_MANAGER_WARNING,
       pval003 P_ASG_FUTURE_CHANGES_WARNING,
       pval004 P_ENTRIES_CHANGED_WARNING,
       pval005 P_PERSON_USER_KEY
from hr_pump_batch_lines
where api_module_id = 1200
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_FINAL_PROCESS_DATE
, PVAL002 P_ORG_NOW_NO_MANAGER_WARNING
, PVAL003 P_ASG_FUTURE_CHANGES_WARNING
, PVAL004 P_ENTRIES_CHANGED_WARNING
, PVAL005 P_PERSON_USER_KEY FROM HR_PUMP_BATCH_LINES WHERE API_MODULE_ID = 1200 WITH CHECK OPTION