APPS.PAY_RETRO_PKG dependencies on DUAL

Line 162: from dual

158: l_result number;
159: begin
160: select 1
161: into l_result
162: from dual
163: where pay_retro_pkg.process_retro_value(
164: p_element_entry_id,
165: p_element_type_id,
166: p_retro_comp_id,

Line 1201: from dual;

1197: asgrec.tax_unit_id,
1198: actrec.assignment_action_id,
1199: actrec.process_group_id,
1200: 'POG'
1201: from dual;
1202: --
1203: update pay_retro_assignments
1204: set retro_assignment_action_id = actrec.assignment_action_id
1205: where assignment_id = asgrec.source_id

Line 1763: from dual;

1759: pay_balance_pkg.maintain_balances_for_action(l_asg_act_id);
1760: -- Bug 8614449 : create a new payroll action
1761: select pay_payroll_actions_s.nextval
1762: into l_pactid
1763: from dual;
1764: --
1765: insert into pay_payroll_actions(
1766: payroll_action_id,
1767: action_type,

Line 1844: from dual;

1840: pay_balance_pkg.maintain_balances_for_action(l_asg_act_id);
1841:
1842: select pay_payroll_actions_s.nextval
1843: into l_pactid
1844: from dual;
1845:
1846: insert into pay_payroll_actions(
1847: payroll_action_id,
1848: action_type,

Line 1891: from dual;

1887: pay_balance_pkg.maintain_balances_for_action(l_asg_act_id);
1888: -- Bug 8614449 : create a new payroll action
1889: select pay_payroll_actions_s.nextval
1890: into l_pactid
1891: from dual;
1892: --
1893: insert into pay_payroll_actions(
1894: payroll_action_id,
1895: action_type,