DBA Data[Home] [Help]

APPS.PAY_IE_EHECS_REPORT_PKG dependencies on DUAL

Line 382: FROM dual;

378: SELECT NVL(hruserdt.get_table_value(p_business_Group_id,'EHECS_CATG_TAB','Managers',p_occupational_category,g_qtr_start_date),
379: NVL(hruserdt.get_table_value(p_business_Group_id,'EHECS_CATG_TAB','Clerical Workers',p_occupational_category,g_qtr_start_date),
380: hruserdt.get_table_value(p_business_Group_id,'EHECS_CATG_TAB','Production Workers',p_occupational_category,g_qtr_start_date))) ff
381: into g_occupational_category_M_C_P
382: FROM dual;
383:
384:
385: END IF;
386:

Line 828: FROM dual;

824: FETCH csr_get_asg INTO l_assg_id;
825: EXIT WHEN csr_get_asg%NOTFOUND;
826: SELECT pay_assignment_actions_s.nextval
827: INTO lockingactid
828: FROM dual;
829:
830: hr_utility.set_location('assignment_action_code, the assignment id finally picked up: '||l_assg_id, 540);
831: -- Insert assignment into PAY_ASSIGNMENT_ACTIONS TABLE
832: /* hr_nonrun_asact.insact(lockingactid => lockingactid