APPS.PAY_IE_NES_REPORT_PKG dependencies on DUAL

Line 492: FROM dual;

488: SELECT NVL(hruserdt.get_table_value(p_business_Group_id,'EHECS_CATG_TAB','Managers',p_occupational_category,g_qtr_start_date),
489: NVL(hruserdt.get_table_value(p_business_Group_id,'EHECS_CATG_TAB','Clerical Workers',p_occupational_category,g_qtr_start_date),
490: hruserdt.get_table_value(p_business_Group_id,'EHECS_CATG_TAB','Production Workers',p_occupational_category,g_qtr_start_date))) ff
491: into g_occupational_category_M_C_P
492: FROM dual;
493:
494:
495: END IF;
496:

Line 1117: FROM dual;

1113: FETCH csr_get_asg INTO l_assg_id;
1114: EXIT WHEN csr_get_asg%NOTFOUND;
1115: SELECT pay_assignment_actions_s.nextval
1116: INTO lockingactid
1117: FROM dual;
1118:
1119: hr_utility.set_location('assignment_action_code, the assignment id finally picked up: '||l_assg_id, 540);
1120:
1121: hr_utility.set_location(' Before hr_nonrun_asact.insact call',550);