APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on DUAL

Line 372: FROM dual;

368: FOR i in csr_bal_init (l_payroll_id,l_canonical_start_date,l_canonical_end_date,l_consolidation_set)
369: LOOP
370: SELECT pay_assignment_actions_s.NEXTVAL
371: INTO l_actid
372: FROM dual;
373:
374: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE 'I' ASSIGNMENT ACTION
375:
376: hr_nonrun_asact.insact(l_actid,i.assignment_id,p_payroll_action_id,p_chunk,NULL);

Line 1022: -- individual balances --

1018: -- 2. Non Taxable Earnings --
1019: -- 3. Statutory Deductions --
1020: -- 4. Voluntary Deductions --
1021: -- It then calls ARCHIVE_BALANCES to archive --
1022: -- individual balances --
1023: -- --
1024: -- Parameters : --
1025: -- IN : p_assignment_action_id NUMBER --
1026: -- p_assignment_id NUMBER --

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

1116: -- Name : ARCHIVE_FORM24Q_BALANCES --
1117: -- Type : PROCEDURE --
1118: -- Access : Private --
1119: -- Description : This procedure calls pay_in_tax_utils. --
1120: -- get_balance_value to archive individual balances for --
1121: -- the following balances --
1122: -- --
1123: -- 1. Net Pay --
1124: -- 2. Income Tax This Pay --

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

1125: -- 3. TDS on Direct Payments --
1126: -- 4. Surcharge This Pay --
1127: -- 5. Education Cess This Pay --
1128: -- It then calls pay_action_information_api. --
1129: -- create_action_information to archive individual balances --
1130: -- --
1131: -- Parameters : --
1132: -- IN : p_assignment_action_id NUMBER --
1133: -- p_assignment_id NUMBER --

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

3323: l_rep_addr:= NULL;
3324: END IF;
3325:
3326: SELECT DECODE(p_context,'PF',l_class,l_rep_addr) INTO l_context
3327: FROM dual;--case p_context when 'PF' then l_class else l_rep_addr end --PF CLass or ESI Org Rep Addr
3328:
3329: pay_action_information_api.create_action_information
3330: (p_action_context_id => l_act_id --Payroll Action id
3331: ,p_action_context_type => 'PA'