APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on DUAL

Line 442: FROM dual;

438: FOR i in csr_bal_init (l_payroll_id,l_canonical_start_date,l_canonical_end_date,l_consolidation_set)
439: LOOP
440: SELECT pay_assignment_actions_s.NEXTVAL
441: INTO l_actid
442: FROM dual;
443:
444: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE 'I' ASSIGNMENT ACTION
445:
446: hr_nonrun_asact.insact(l_actid,i.assignment_id,p_payroll_action_id,p_chunk,NULL);

Line 1092: -- individual balances --

1088: -- 2. Non Taxable Earnings --
1089: -- 3. Statutory Deductions --
1090: -- 4. Voluntary Deductions --
1091: -- It then calls ARCHIVE_BALANCES to archive --
1092: -- individual balances --
1093: -- --
1094: -- Parameters : --
1095: -- IN : p_assignment_action_id NUMBER --
1096: -- p_assignment_id NUMBER --

Line 1190: -- get_balance_value to archive individual balances for --

1186: -- Name : ARCHIVE_FORM24Q_BALANCES --
1187: -- Type : PROCEDURE --
1188: -- Access : Private --
1189: -- Description : This procedure calls pay_in_tax_utils. --
1190: -- get_balance_value to archive individual balances for --
1191: -- the following balances --
1192: -- --
1193: -- 1. Net Pay --
1194: -- 2. Income Tax This Pay --

Line 1199: -- create_action_information to archive individual balances --

1195: -- 3. TDS on Direct Payments --
1196: -- 4. Surcharge This Pay --
1197: -- 5. Education Cess This Pay --
1198: -- It then calls pay_action_information_api. --
1199: -- create_action_information to archive individual balances --
1200: -- --
1201: -- Parameters : --
1202: -- IN : p_assignment_action_id NUMBER --
1203: -- p_assignment_id NUMBER --

Line 3546: FROM dual;--case p_context when 'PF' then l_class else l_rep_addr end --PF CLass or ESI Org Rep Addr

3542: l_rep_addr:= NULL;
3543: END IF;
3544:
3545: SELECT DECODE(p_context,'PF',l_class,l_rep_addr) INTO l_context
3546: FROM dual;--case p_context when 'PF' then l_class else l_rep_addr end --PF CLass or ESI Org Rep Addr
3547:
3548: pay_action_information_api.create_action_information
3549: (p_action_context_id => l_act_id --Payroll Action id
3550: ,p_action_context_type => 'PA'