APPS.PAY_GB_RTI_P60 dependencies on DUAL

Line 635: FROM dual;

631:
632: CURSOR csr_tax_pay_value(p_last_asg_action_id number,l_tax_pay_def_bal_id number)
633: IS
634: SELECT hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id)
635: FROM dual;
636:
637: --Below cursor fetches period type of the current assignment
638: CURSOR csr_get_period_type
639: IS

Line 2082: FROM dual;

2078: AND pbt.legislation_code = 'GB';
2079: CURSOR csr_tax_pay_value(p_last_asg_action_id NUMBER,l_tax_pay_def_bal_id NUMBER)
2080: IS
2081: SELECT hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id)
2082: FROM dual;
2083:
2084: cursor csr_reversal is
2085: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa
2086: where paa.assignment_action_id = l_last_asg_action_id

Line 2541: FROM dual;

2537: AND pbt.legislation_code = 'GB';
2538: CURSOR csr_tax_pay_value(p_last_asg_action_id NUMBER,l_tax_pay_def_bal_id NUMBER)
2539: IS
2540: SELECT hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id)
2541: FROM dual;
2542:
2543: cursor csr_reversal is
2544: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa
2545: where paa.assignment_action_id = l_last_asg_action_id

Line 2808: FROM dual;

2804: AND pbt.legislation_code = 'GB';
2805: CURSOR csr_tax_pay_value(p_last_asg_action_id NUMBER,l_tax_pay_def_bal_id NUMBER)
2806: IS
2807: SELECT hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id)
2808: FROM dual;
2809:
2810: cursor csr_reversal is
2811: select ACTION_TYPE from pay_assignment_actions paa, pay_payroll_actions ppa
2812: where paa.assignment_action_id = l_last_asg_action_id

Line 3194: sqlstr := 'select 1 from dual where to_char(:payroll_action_id) = dummy';

3190: hr_utility.set_location(' Leaving: '||l_proc,50);
3191: fnd_file.put_line(fnd_file.log,
3192: substr('Error in rangecode '||sqlerrm(sqlcode),1,80));
3193: -- Return cursor that selects no rows
3194: sqlstr := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
3195: END range_cursor;
3196:
3197: --
3198: --

Line 3562: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;

3558: l_flag:= 'N';
3559: END IF;
3560:
3561: if l_flag = 'Y' Then --and l_first_fps_prepay_asg = 'N' Then
3562: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
3563: -- Insert assignment into pay_assignment_actions
3564: hr_nonrun_asact.insact(lockingactid, asg_record.assignment_id, pactid, chunk, NULL);
3565: hr_nonrun_asact.insint(lockingactid, l_last_asg_action_id);
3566: End if;