APPS.PAY_IN_24QC_ARCHIVE dependencies on DUAL

Line 3813: FROM dual;

3809: pay_in_utils.get_ee_value(p_element_entry_id,'Income Tax Deducted') Income_Tax_Deducted,
3810: pay_in_utils.get_ee_value(p_element_entry_id,'Surcharge Deducted') Surcharge_Deducted,
3811: pay_in_utils.get_ee_value(p_element_entry_id,'Education Cess Deducted') Education_Cess_Deducted,
3812: pay_in_utils.get_ee_value(p_element_entry_id,'Amount Deposited') Amount_Deposited
3813: FROM dual;
3814:
3815: CURSOR c_get_ee_from_24q_data
3816: IS
3817: SELECT action_information1 Challan_or_Voucher_Number,

Line 7620: FROM dual;

7616: THEN
7617: pay_in_utils.set_location(g_debug,'Archiving ORG data',1);
7618: SELECT DECODE(DECODE(g_24qc_empr_change,'N',DECODE(g_24qc_rep_adr_chg,'Y','Y','N'),'Y'),'Y',1,0)
7619: INTO l_batch_upd_indicator
7620: FROM dual;
7621:
7622: pay_in_utils.set_location(g_debug,'Checking Last NIL Challan Indicator details ',6);
7623: OPEN c_24qa_nil_challan_indicator(l_tan_number);
7624: FETCH c_24qa_nil_challan_indicator INTO l_old_nil_challan;

Line 7896: FROM dual;

7892: IF (l_action_id IS NULL)
7893: THEN
7894: SELECT pay_assignment_actions_s.NEXTVAL
7895: INTO l_action_id
7896: FROM dual;
7897:
7898: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 11);
7899: pay_in_utils.set_location(g_debug,'Value of l_locked_action_id is '|| c_rec.assignment_action_id, 12);
7900: pay_in_utils.set_location(g_debug,'Value of assignment_id is '|| c_rec.assignment_id, 13);

Line 7932: FROM dual;

7928: IF (l_action_id IS NULL)
7929: THEN
7930: SELECT pay_assignment_actions_s.NEXTVAL
7931: INTO l_action_id
7932: FROM dual;
7933:
7934: pay_in_utils.set_location(g_debug,'Inserting Assignment Actions as it was null', 14);
7935: hr_nonrun_asact.insact(lockingactid => l_action_id
7936: ,assignid => c_rec.assignment_id

Line 7984: FROM dual;

7980: IF (l_action_id IS NULL)
7981: THEN
7982: SELECT pay_assignment_actions_s.NEXTVAL
7983: INTO l_action_id
7984: FROM dual;
7985:
7986: pay_in_utils.set_location(g_debug,'Inserting Assignment Actions as it was null', 14);
7987: hr_nonrun_asact.insact(lockingactid => l_action_id
7988: ,assignid => c_rec.assignment_id

Line 8496: FROM dual;

8492: IF (l_dummy IS NULL)
8493: THEN
8494: SELECT pay_assignment_actions_s.NEXTVAL
8495: INTO l_action_id
8496: FROM dual;
8497:
8498: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);
8499: pay_in_utils.set_location(g_debug,'Inserting Assignment action id ',61);
8500:

Line 8645: FROM dual;

8641: IF (l_dummy IS NULL)
8642: THEN
8643: SELECT pay_assignment_actions_s.NEXTVAL
8644: INTO l_action_id
8645: FROM dual;
8646:
8647: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);
8648: pay_in_utils.set_location(g_debug,'Inserting Assignment action id ',61);
8649:

Line 8796: FROM dual;

8792: IF (l_dummy IS NULL)
8793: THEN
8794: SELECT pay_assignment_actions_s.NEXTVAL
8795: INTO l_action_id
8796: FROM dual;
8797:
8798: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);
8799: pay_in_utils.set_location(g_debug,'Inserting Assignment action id ',61);
8800:

Line 8959: FROM dual;

8955: IF (l_dummy IS NULL)
8956: THEN
8957: SELECT pay_assignment_actions_s.NEXTVAL
8958: INTO l_action_id
8959: FROM dual;
8960:
8961: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);
8962: pay_in_utils.set_location(g_debug,'Inserting Assignment action id ',61);
8963:

Line 9035: FROM dual;

9031: IF (l_dummy IS NULL)
9032: THEN
9033: SELECT pay_assignment_actions_s.NEXTVAL
9034: INTO l_action_id
9035: FROM dual;
9036:
9037: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);
9038: pay_in_utils.set_location(g_debug,'Inserting Assignment action id ',61);
9039:

Line 9115: FROM dual;

9111: IF (l_dummy IS NULL)
9112: THEN
9113: SELECT pay_assignment_actions_s.NEXTVAL
9114: INTO l_action_id
9115: FROM dual;
9116:
9117: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);
9118: pay_in_utils.set_location(g_debug,'Inserting Assignment action id ',61);
9119: