APPS.PAY_NO_UNION_DUES dependencies on DUAL

Line 186: select to_char(l_effective_date,'RRRR') into l_bimonth_year from dual;

182: CLOSE csr_le_details ;
183:
184: -- get the bimonth year
185: begin
186: select to_char(l_effective_date,'RRRR') into l_bimonth_year from dual;
187: exception
188: when others then
189: null;
190: end;

Line 396: SELECT pay_assignment_actions_s.NEXTVAL INTO l_actid FROM dual;

392: ,l_payee_org)
393: LOOP
394:
395: begin
396: SELECT pay_assignment_actions_s.NEXTVAL INTO l_actid FROM dual;
397: exception
398: when others then
399: null;
400: end;

Line 668: from dual;

664: begin
665: select pay_balance_pkg.get_value(pay_no_emp_cont.get_defined_balance_id('Subject to Union Dues','_ASG_PTD'),
666: l_main_asg_act_id)
667: into l_tax_dedn_basis
668: from dual;
669: exception
670: when others then
671: null;
672: end;