APPS.PAY_BALANCE_PKG dependencies on DUAL

Line 5588: from dual;

5584: -- get the next value for payroll action id
5585: --
5586: select pay_payroll_actions_s.nextval
5587: into l_pay_action_id
5588: from dual;
5589: --
5590: -- insert a temporary row into pay_payroll_actions
5591: --
5592: if g_debug then

Line 5946: select '1' from dual

5942: and pbv.run_balance_status in ('P', 'V');
5943:
5944: -- Select if run result value exists for input value
5945: cursor ivchk is
5946: select '1' from dual
5947: where exists
5948: (select /*+ ORDERED INDEX(RRV PAY_RUN_RESULT_VALUES_PK)
5949: INDEX(PRR PAY_RUN_RESULTS_PK) */
5950: 1

Line 6445: from dual;

6441: --
6442: --
6443: select pay_run_balances_s.nextval
6444: into l_grp_run_bal_id
6445: from dual;
6446: --
6447: split_jurisdiction(p_jur_code,
6448: l_jur1,
6449: l_jur2,

Line 7644: from dual

7640: begin
7641: --
7642: select 1
7643: into l_dummy
7644: from dual
7645: where exists (select ''
7646: from pay_run_balances
7647: where defined_balance_id = p_defined_balance_lst(cnt).defined_balance_id
7648: and assignment_action_id = p_asgact_id

Line 7901: from dual

7897: l_dummy number;
7898: begin
7899: select 1
7900: into l_dummy
7901: from dual
7902: where exists (select ''
7903: from pay_run_balances
7904: where defined_balance_id = p_def_bal_id
7905: and payroll_action_id = p_pactid

Line 8708: from dual

8704: l_dummy number;
8705: begin
8706: select 1
8707: into l_dummy
8708: from dual
8709: where exists (select ''
8710: from pay_run_balances
8711: where defined_balance_id = p_def_bal_id
8712: and assignment_action_id = p_asgact_id

Line 9743: from dual

9739: l_dummy number;
9740: begin
9741: select 1
9742: into l_dummy
9743: from dual
9744: where exists (select 1
9745: from pay_run_balances
9746: where defined_balance_id = p_defined_balance_lst(cnt).defined_balance_id
9747: and payroll_action_id = p_pact_id

Line 10068: from dual

10064: --
10065: cursor check_run_results(p_baltype_id in number)
10066: is
10067: select 1
10068: from dual
10069: where exists (select /*+ ORDERED*/
10070: null
10071: from pay_balance_feeds_f bf
10072: , pay_run_result_values rrv

Line 10162: from dual

10158: ,p_defbal_id
10159: ,each_bg.business_group_id
10160: ,'V'
10161: ,l_bal_load_date
10162: from dual
10163: where not exists (select 1
10164: from pay_balance_validation
10165: where defined_balance_id = p_defbal_id
10166: and business_group_id = each_bg.business_group_id);