APPS.PAY_US_SQWL_GRE dependencies on DUAL

Line 183: FROM dual;

179: lv_reporting_quarter:=to_char(ld_Quater_end_date,'MMYYYY');
180:
181: SELECT pay_payroll_actions_s.nextval
182: INTO ln_locking_action_id
183: FROM dual;
184:
185: /*g_payroll_action_id:=ln_locking_action_id;*/
186:
187: OPEN c_get_format_type(p_state,p_format);

Line 285: FROM dual;

281: p_state,
282: to_char(ld_Quater_end_date,'YYYY/MM/DD') ||' 00:00:00',
283: substr(lv_format_meaning,1,1) )
284: INTO l_file_name
285: FROM dual;
286:
287: hr_utility.trace('c_get_all_gres_rec.organization_id : '||c_get_all_gres_rec.organization_id);
288:
289:

Line 352: FROM dual;

348: p_state,
349: to_char(ld_Quater_end_date,'YYYY/MM/DD') ||' 00:00:00',
350: substr(lv_format_meaning,1,1) )
351: INTO l_file_name
352: FROM dual;
353:
354:
355: BEGIN
356: l_req_id := fnd_request.submit_request(application => 'PAY',

Line 726: FROM dual;

722: lv_reporting_month:=to_char(ld_Month_end_date,'MMYYYY');
723:
724: SELECT pay_payroll_actions_s.nextval
725: INTO ln_locking_action_id
726: FROM dual;
727:
728: /*g_payroll_action_id:=ln_locking_action_id;*/
729:
730: OPEN c_get_format_type(p_state,p_format);

Line 828: FROM dual;

824: p_state,
825: to_char(ld_Month_end_date,'YYYY/MM/DD') ||' 00:00:00',
826: substr(lv_format_meaning,1,1) )
827: INTO l_file_name
828: FROM dual;
829:
830: hr_utility.trace('c_get_all_gres_rec.organization_id : '||c_get_all_gres_rec.organization_id);
831:
832:

Line 895: FROM dual;

891: p_state,
892: to_char(ld_Month_end_date,'YYYY/MM/DD') ||' 00:00:00',
893: substr(lv_format_meaning,1,1) )
894: INTO l_file_name
895: FROM dual;
896:
897:
898: BEGIN
899: l_req_id := fnd_request.submit_request(application => 'PAY',