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 395: SELECT pay_assignment_actions_s.NEXTVAL INTO l_actid FROM dual;

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

Line 665: from dual;

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