APPS.PAY_IN_24QC_ARCHIVE dependencies on DUAL

Line 4137: FROM dual;

4133: pay_in_utils.get_ee_value(p_element_entry_id,'Income Tax Deducted') Income_Tax_Deducted,
4134: pay_in_utils.get_ee_value(p_element_entry_id,'Surcharge Deducted') Surcharge_Deducted,
4135: pay_in_utils.get_ee_value(p_element_entry_id,'Education Cess Deducted') Education_Cess_Deducted,
4136: pay_in_utils.get_ee_value(p_element_entry_id,'Amount Deposited') Amount_Deposited
4137: FROM dual;
4138:
4139: CURSOR c_get_ee_from_24q_data
4140: IS
4141: SELECT action_information1 Challan_or_Voucher_Number,

Line 7978: FROM dual;

7974: THEN
7975: pay_in_utils.set_location(g_debug,'Archiving ORG data',1);
7976: SELECT DECODE(DECODE(g_24qc_empr_change,'N',DECODE(g_24qc_rep_adr_chg,'Y','Y','N'),'Y'),'Y',1,0)
7977: INTO l_batch_upd_indicator
7978: FROM dual;
7979:
7980: pay_in_utils.set_location(g_debug,'Checking Last NIL Challan Indicator details ',6);
7981: OPEN c_24qa_nil_challan_indicator(l_tan_number);
7982: FETCH c_24qa_nil_challan_indicator INTO l_old_nil_challan;

Line 8275: FROM dual;

8271: IF (l_action_id IS NULL)
8272: THEN
8273: SELECT pay_assignment_actions_s.NEXTVAL
8274: INTO l_action_id
8275: FROM dual;
8276:
8277: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 11);
8278: pay_in_utils.set_location(g_debug,'Value of l_locked_action_id is '|| c_rec.assignment_action_id, 12);
8279: pay_in_utils.set_location(g_debug,'Value of assignment_id is '|| c_rec.assignment_id, 13);

Line 8311: FROM dual;

8307: IF (l_action_id IS NULL)
8308: THEN
8309: SELECT pay_assignment_actions_s.NEXTVAL
8310: INTO l_action_id
8311: FROM dual;
8312:
8313: pay_in_utils.set_location(g_debug,'Inserting Assignment Actions as it was null', 14);
8314: hr_nonrun_asact.insact(lockingactid => l_action_id
8315: ,assignid => c_rec.assignment_id

Line 8363: FROM dual;

8359: IF (l_action_id IS NULL)
8360: THEN
8361: SELECT pay_assignment_actions_s.NEXTVAL
8362: INTO l_action_id
8363: FROM dual;
8364:
8365: pay_in_utils.set_location(g_debug,'Inserting Assignment Actions as it was null', 14);
8366: hr_nonrun_asact.insact(lockingactid => l_action_id
8367: ,assignid => c_rec.assignment_id

Line 8898: FROM dual;

8894: IF (l_dummy IS NULL)
8895: THEN
8896: SELECT pay_assignment_actions_s.NEXTVAL
8897: INTO l_action_id
8898: FROM dual;
8899:
8900: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);
8901: pay_in_utils.set_location(g_debug,'Inserting Assignment action id ',61);
8902:

Line 9047: FROM dual;

9043: IF (l_dummy IS NULL)
9044: THEN
9045: SELECT pay_assignment_actions_s.NEXTVAL
9046: INTO l_action_id
9047: FROM dual;
9048:
9049: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);
9050: pay_in_utils.set_location(g_debug,'Inserting Assignment action id ',61);
9051:

Line 9198: FROM dual;

9194: IF (l_dummy IS NULL)
9195: THEN
9196: SELECT pay_assignment_actions_s.NEXTVAL
9197: INTO l_action_id
9198: FROM dual;
9199:
9200: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);
9201: pay_in_utils.set_location(g_debug,'Inserting Assignment action id ',61);
9202:

Line 9361: FROM dual;

9357: IF (l_dummy IS NULL)
9358: THEN
9359: SELECT pay_assignment_actions_s.NEXTVAL
9360: INTO l_action_id
9361: FROM dual;
9362:
9363: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);
9364: pay_in_utils.set_location(g_debug,'Inserting Assignment action id ',61);
9365:

Line 9437: FROM dual;

9433: IF (l_dummy IS NULL)
9434: THEN
9435: SELECT pay_assignment_actions_s.NEXTVAL
9436: INTO l_action_id
9437: FROM dual;
9438:
9439: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);
9440: pay_in_utils.set_location(g_debug,'Inserting Assignment action id ',61);
9441:

Line 9517: FROM dual;

9513: IF (l_dummy IS NULL)
9514: THEN
9515: SELECT pay_assignment_actions_s.NEXTVAL
9516: INTO l_action_id
9517: FROM dual;
9518:
9519: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);
9520: pay_in_utils.set_location(g_debug,'Inserting Assignment action id ',61);
9521: