APPS.PAY_BALANCE_PKG dependencies on DUAL

Line 5890: from dual;

5886: -- get the next value for payroll action id
5887: --
5888: select pay_payroll_actions_s.nextval
5889: into l_pay_action_id
5890: from dual;
5891: --
5892: -- insert a temporary row into pay_payroll_actions
5893: --
5894: if g_debug then

Line 6358: select '1' from dual

6354: ;
6355:
6356: -- Select if run result value exists for input value
6357: cursor ivchk is
6358: select '1' from dual
6359: where exists
6360: (select 1
6361: from pay_run_result_values rrv
6362: where rrv.input_value_id = p_input_value_id);

Line 6939: from dual;

6935: --
6936: --
6937: select pay_run_balances_s.nextval
6938: into l_grp_run_bal_id
6939: from dual;
6940: --
6941: split_jurisdiction(p_jur_code,
6942: l_jur1,
6943: l_jur2,

Line 7466: from dual;

7462: i:=i+1;
7463:
7464: select pay_run_balances_s.nextval
7465: into lv_run_balance_id
7466: from dual;
7467:
7468: split_jurisdiction(p_output_list(cnt).jurisdiction_code,
7469: l_jur1,
7470: l_jur2,

Line 8217: from dual

8213: begin
8214: --
8215: select 1
8216: into l_dummy
8217: from dual
8218: where exists (select ''
8219: from pay_run_balances
8220: where defined_balance_id = p_defined_balance_lst(cnt).defined_balance_id
8221: and assignment_action_id = p_asgact_id

Line 8499: from dual

8495: l_dummy number;
8496: begin
8497: select 1
8498: into l_dummy
8499: from dual
8500: where exists (select ''
8501: from pay_run_balances
8502: where defined_balance_id = p_def_bal_id
8503: and payroll_action_id = p_pactid

Line 9369: from dual

9365: l_dummy number;
9366: begin
9367: select 1
9368: into l_dummy
9369: from dual
9370: where exists (select ''
9371: from pay_run_balances
9372: where defined_balance_id = p_def_bal_id
9373: and assignment_action_id = p_asgact_id

Line 10450: from dual

10446: l_dummy number;
10447: begin
10448: select 1
10449: into l_dummy
10450: from dual
10451: where exists (select 1
10452: from pay_run_balances
10453: where defined_balance_id = p_defined_balance_lst(cnt).defined_balance_id
10454: and payroll_action_id = p_pact_id

Line 10789: from dual

10785: --
10786: cursor check_run_results(p_baltype_id in number)
10787: is
10788: select 1
10789: from dual
10790: where exists (select /*+ ORDERED*/
10791: null
10792: from pay_balance_feeds_f bf
10793: , pay_run_result_values rrv

Line 10883: from dual

10879: ,p_defbal_id
10880: ,each_bg.business_group_id
10881: ,'V'
10882: ,l_bal_load_date
10883: from dual
10884: where not exists (select 1
10885: from pay_balance_validation
10886: where defined_balance_id = p_defbal_id
10887: and business_group_id = each_bg.business_group_id);