eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_RTI_FPS dependencies on DUAL

Line 520: || 'FROM DUAL';

516: l_sqlstr :=
517: 'SELECT '
518: || l_package
519: || ' (:p_assignment_id,:p_eff_date) '
520: || 'FROM DUAL';
521: EXECUTE IMMEDIATE l_sqlstr into l_hours_worked_asg USING asg_rec.assignment_id,l_asg_eff_date;
522: l_hours_worked := nvl(l_hours_worked,0) + l_hours_worked_asg;
523: end loop;
524: else

Line 529: || 'FROM DUAL';

525: l_sqlstr :=
526: 'SELECT '
527: || l_package
528: || ' (:p_assignment_id,:p_eff_date) '
529: || 'FROM DUAL';
530: EXECUTE IMMEDIATE l_sqlstr into l_hours_worked USING p_assignment_id,l_effective_date;
531: end if; -- end paye agg
532: if l_hours_worked = 0 then
533: l_hours_worked := 'D';

Line 744: || 'FROM DUAL';

740: l_sqlstr :=
741: 'SELECT '
742: || l_package
743: || ' (:p_assignment_id,:p_eff_date) '
744: || 'FROM DUAL';
745: EXECUTE IMMEDIATE l_sqlstr into l_periods_covered USING p_assignment_id,l_effective_date;
746:
747: hr_utility.trace('Function value l_periods_covered '||l_periods_covered);
748:

Line 899: || 'FROM DUAL';

895: l_sqlstr :=
896: 'SELECT '
897: || l_package
898: || ' (:p_assignment_id,:p_eff_date) '
899: || 'FROM DUAL';
900:
901: EXECUTE IMMEDIATE l_sqlstr into l_irregular_payment USING p_assignment_id,l_effective_date;
902:
903: hr_utility.trace('Function value l_irregular_payment '||l_irregular_payment);

Line 1053: || 'FROM DUAL';

1049: l_sqlstr :=
1050: 'SELECT '
1051: || l_package
1052: || ' (:p_assignment_id,:p_eff_date) '
1053: || 'FROM DUAL';
1054: EXECUTE IMMEDIATE l_sqlstr into l_oneoff_payment USING p_assignment_id,l_effective_date;
1055:
1056: hr_utility.trace('Function value l_oneoff_payment '||l_oneoff_payment);
1057: --EXECUTE IMMEDIATE 'CALL ' || l_package || '() INTO :l_periods_covered' USING OUT l_oneoff_payment;

Line 1198: || 'FROM DUAL';

1194: sqlstr :=
1195: 'SELECT '
1196: || l_package
1197: || ' (:p_person_id,:p_eff_date) '
1198: || 'FROM DUAL';
1199: hr_utility.set_location(sqlstr,1);
1200: EXECUTE IMMEDIATE sqlstr into l_passport_number USING p_person_id,l_effective_date;
1201: hr_utility.trace('Function value l_passport_number '||l_passport_number);
1202: exception

Line 2037: ) into l_periods_covered from dual;

2033: pay_advance_pay_pkg.advanced_periods(
2034: p_person_rec.assignment_id,
2035: l_start_date,
2036: l_end_date
2037: ) into l_periods_covered from dual;
2038: hr_utility.trace('test4');
2039: -- reset the periods covered value to 1
2040: elsif l_periods_covered IS NOT NULL AND l_periods_covered <> 1 THEN
2041: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,

Line 2874: ) into l_periods_covered from dual;

2870: pay_advance_pay_pkg.advanced_periods(
2871: p_person_rec.assignment_id,
2872: l_start_date,
2873: l_end_date
2874: ) into l_periods_covered from dual;
2875: hr_utility.trace('test4');
2876: -- reset the periods covered value to 1
2877: elsif l_periods_covered IS NOT NULL AND l_periods_covered <> 1 THEN
2878: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,

Line 3661: ) into l_periods_covered from dual;

3657: pay_advance_pay_pkg.advanced_periods(
3658: l_asg_id,
3659: l_start_date,
3660: l_end_date
3661: ) into l_periods_covered from dual;
3662: hr_utility.trace('test4');
3663: -- reset the periods covered value to 1
3664: elsif l_periods_covered IS NOT NULL AND l_periods_covered <> 1 THEN
3665: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,

Line 4535: select hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id) from dual;

4531: pbt.legislation_code = 'GB';
4532:
4533: cursor csr_tax_pay_value(p_last_asg_action_id number,l_tax_pay_def_bal_id number)
4534: is
4535: select hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id) from dual;
4536:
4537: CURSOR csr_max_child_act_id(c_lst_act_id NUMBER)
4538: IS
4539: SELECT max(assignment_action_id)

Line 5202: select hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id) from dual;

5198: pbt.legislation_code = 'GB';
5199:
5200: cursor csr_tax_pay_value(p_last_asg_action_id number,l_tax_pay_def_bal_id number)
5201: is
5202: select hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id) from dual;
5203:
5204: CURSOR csr_max_child_act_id(c_lst_act_id NUMBER)
5205: IS
5206: SELECT max(assignment_action_id)

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

6884: end if;
6885: end if; --if (l_flag = 'Y') then
6886:
6887: if l_flag = 'Y' and l_first_fps_prepay_asg = 'N' Then
6888: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
6889: -- Insert assignment into pay_assignment_actions
6890: hr_nonrun_asact.insact ( lockingactid, asg_record.assignment_id, pactid, chunk, NULL );
6891: End if;
6892:

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

6977:
6978: if ((asg_rec.asg_act_id = l_aggr_min_act_id) and (l_earlier_processed = 0)) then
6979: hr_utility.set_location('Creating Assignment Action for assignment_id '||asg_rec.assignment_id, 50);
6980:
6981: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
6982: hr_nonrun_asact.insact ( lockingactid, asg_rec.assignment_id, pactid, chunk, NULL );
6983: -- get the assigment action id of the prepayment payroll action id for the current assignment.
6984: OPEN csr_prepay_asg_act_details(asg_rec.assignment_id, l_pre_pact_id);
6985: FETCH csr_prepay_asg_act_details

Line 6998: /* SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;

6994: hr_utility.set_location('Creating other Assignment Action ids for assignment_id '||asg_rec.assignment_id, 50);
6995:
6996: /*for c_asg in csr_get_other_asg(asg_rec.assignment_id)
6997: loop*/
6998: /* SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
6999: hr_utility.set_location('Creating action for asg '||c_asg.asg_id, 50);
7000: hr_nonrun_asact.insact(lockingactid, c_asg.asg_id, pactid, chunk, NULL );
7001: hr_utility.set_location('Created action for asg '||c_asg.asg_id, 50);*/
7002:

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

7010: FETCH csr_agg_all_asg_act_creat
7011: INTO l_asg_id;
7012:
7013: EXIT WHEN csr_agg_all_asg_act_creat%NOTFOUND;
7014: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7015: hr_utility.set_location('Creating action for asg '||l_asg_id, 50);
7016: hr_nonrun_asact.insact(lockingactid, l_asg_id, pactid, chunk, NULL );
7017: hr_utility.set_location('Created action for asg '||l_asg_id, 50);
7018:

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

7055:
7056: ELSIF l_flag1 = 'Y' THEN
7057: -- Create one assignment action for every assignment
7058: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);
7059: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7060:
7061: -- Insert assignment into pay_assignment_actions
7062: hr_nonrun_asact.insact ( lockingactid, asg_rec.assignment_id, pactid, chunk, NULL );
7063: -- get the assigment action id of the prepayment payroll action id for the current assignment.

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

7102: hr_utility.set_location('l_ni_aggr_max_act_id:'|| l_ni_aggr_max_act_id , 50);
7103: hr_utility.set_location('asg_rec.asg_act_id:'|| asg_rec.asg_act_id , 50);
7104: if nvl(l_rti_ni_proc_flag,'N') <> 'Y' and asg_rec.asg_act_id = l_ni_aggr_max_act_id then
7105: hr_utility.set_location('Creating action for rti rpt asg:'|| l_ni_rpt_asg_id, 50);
7106: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7107: -- Insert assignment into pay_assignment_actions
7108: hr_nonrun_asact.insact ( lockingactid, l_ni_rpt_asg_id, pactid, chunk, NULL );
7109: /* -- get the assigment action id of the prepayment payroll action id for the current assignment.
7110: OPEN csr_ni_prepay_asg_act_details(asg_rec.asg_act_id);

Line 8462: from dual

8458: CURSOR csr_aggr_locking_asg_act_id(p_person_id NUMBER, p_action_sequence NUMBER)
8459: IS
8460: /*
8461: select null into dummy
8462: from dual
8463: where not exists
8464: (select null
8465: */
8466: SELECT min (act.assignment_action_id)