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_ARCHIVE dependencies on DUAL

Line 395: || 'FROM DUAL';

391: l_sqlstr :=
392: 'SELECT '
393: || l_package
394: || ' (:p_assignment_id,:p_eff_date) '
395: || 'FROM DUAL';
396: EXECUTE IMMEDIATE l_sqlstr into l_hours_worked_asg USING asg_rec.assignment_id,l_asg_eff_date;
397: l_hours_worked := nvl(l_hours_worked,0) + l_hours_worked_asg;
398: end loop;
399: else

Line 404: || 'FROM DUAL';

400: l_sqlstr :=
401: 'SELECT '
402: || l_package
403: || ' (:p_assignment_id,:p_eff_date) '
404: || 'FROM DUAL';
405: EXECUTE IMMEDIATE l_sqlstr into l_hours_worked USING p_assignment_id,l_effective_date;
406: end if; -- end paye agg
407: if l_hours_worked = 0 then
408: l_hours_worked := 'D';

Line 619: || 'FROM DUAL';

615: l_sqlstr :=
616: 'SELECT '
617: || l_package
618: || ' (:p_assignment_id,:p_eff_date) '
619: || 'FROM DUAL';
620: EXECUTE IMMEDIATE l_sqlstr into l_periods_covered USING p_assignment_id,l_effective_date;
621:
622: hr_utility.trace('Function value l_periods_covered '||l_periods_covered);
623:

Line 774: || 'FROM DUAL';

770: l_sqlstr :=
771: 'SELECT '
772: || l_package
773: || ' (:p_assignment_id,:p_eff_date) '
774: || 'FROM DUAL';
775:
776: EXECUTE IMMEDIATE l_sqlstr into l_irregular_payment USING p_assignment_id,l_effective_date;
777:
778: hr_utility.trace('Function value l_irregular_payment '||l_irregular_payment);

Line 928: || 'FROM DUAL';

924: l_sqlstr :=
925: 'SELECT '
926: || l_package
927: || ' (:p_assignment_id,:p_eff_date) '
928: || 'FROM DUAL';
929: EXECUTE IMMEDIATE l_sqlstr into l_oneoff_payment USING p_assignment_id,l_effective_date;
930:
931: hr_utility.trace('Function value l_oneoff_payment '||l_oneoff_payment);
932: --EXECUTE IMMEDIATE 'CALL ' || l_package || '() INTO :l_periods_covered' USING OUT l_oneoff_payment;

Line 1070: || 'FROM DUAL';

1066: l_sqlstr :=
1067: 'SELECT '
1068: || l_package
1069: || ' (:p_assignment_id,:p_eff_date) '
1070: || 'FROM DUAL';
1071: EXECUTE IMMEDIATE l_sqlstr into l_pay_non_indiv_ind USING p_assignment_id,l_effective_date;
1072:
1073: hr_utility.trace('Function value get_payment_non_indiv '||l_pay_non_indiv_ind);
1074:

Line 1212: || 'FROM DUAL';

1208: l_sqlstr :=
1209: 'SELECT '
1210: || l_package
1211: || ' (:p_assignment_id,:p_eff_date) '
1212: || 'FROM DUAL';
1213: EXECUTE IMMEDIATE l_sqlstr into l_onstrike_ind USING p_assignment_id,l_effective_date;
1214:
1215: hr_utility.trace('Function value l_onstrike_ind '||l_onstrike_ind);
1216:

Line 1353: || 'FROM DUAL';

1349: l_sqlstr :=
1350: 'SELECT '
1351: || l_package
1352: || ' (:p_assignment_id,:p_eff_date) '
1353: || 'FROM DUAL';
1354: EXECUTE IMMEDIATE l_sqlstr into l_unpaid_absence_ind USING p_assignment_id,l_effective_date;
1355:
1356: hr_utility.trace('Function value l_unpaid_absence_ind '||l_unpaid_absence_ind);
1357:

Line 1498: || 'FROM DUAL';

1494: sqlstr :=
1495: 'SELECT '
1496: || l_package
1497: || ' (:p_person_id,:p_eff_date) '
1498: || 'FROM DUAL';
1499: hr_utility.set_location(sqlstr,1);
1500: EXECUTE IMMEDIATE sqlstr into l_passport_number USING p_person_id,l_effective_date;
1501: hr_utility.trace('Function value l_passport_number '||l_passport_number);
1502: exception

Line 1689: --Fetch Payment to Non Individual, OnStrike and Unpaid Absence Indicators

1685: l_onstrike,
1686: l_unpaid_absence;
1687: CLOSE csr_fetch_other_fields;
1688:
1689: --Fetch Payment to Non Individual, OnStrike and Unpaid Absence Indicators
1690: -- From Configuration
1691:
1692: if l_payment_nonindiv is null then
1693: l_payment_nonindiv := get_payment_non_indiv(l_asg_id);

Line 2531: ) into l_periods_covered from dual;

2527: pay_advance_pay_pkg.advanced_periods(
2528: p_person_rec.assignment_id,
2529: l_start_date,
2530: l_end_date
2531: ) into l_periods_covered from dual;
2532: hr_utility.trace('test4');
2533: -- reset the periods covered value to 1
2534: elsif l_periods_covered IS NOT NULL AND l_periods_covered <> 1 THEN
2535: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,

Line 3339: ) into l_periods_covered from dual;

3335: pay_advance_pay_pkg.advanced_periods(
3336: p_person_rec.assignment_id,
3337: l_start_date,
3338: l_end_date
3339: ) into l_periods_covered from dual;
3340: hr_utility.trace('test4');
3341: -- reset the periods covered value to 1
3342: elsif l_periods_covered IS NOT NULL AND l_periods_covered <> 1 THEN
3343: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,

Line 4113: ) into l_periods_covered from dual;

4109: pay_advance_pay_pkg.advanced_periods(
4110: l_asg_id,
4111: l_start_date,
4112: l_end_date
4113: ) into l_periods_covered from dual;
4114: hr_utility.trace('test4');
4115: -- reset the periods covered value to 1
4116: elsif l_periods_covered IS NOT NULL AND l_periods_covered <> 1 THEN
4117: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,

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

5129: pbt.legislation_code = 'GB';
5130:
5131: cursor csr_tax_pay_value(p_last_asg_action_id number,l_tax_pay_def_bal_id number)
5132: is
5133: select hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id) from dual;
5134:
5135: CURSOR csr_max_child_act_id(c_lst_act_id NUMBER)
5136: IS
5137: SELECT max(assignment_action_id)

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

5812: pbt.legislation_code = 'GB';
5813:
5814: cursor csr_tax_pay_value(p_last_asg_action_id number,l_tax_pay_def_bal_id number)
5815: is
5816: select hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id) from dual;
5817:
5818: CURSOR csr_max_child_act_id(c_lst_act_id NUMBER)
5819: IS
5820: SELECT max(assignment_action_id)

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

7551: end if;
7552: end if; --if (l_flag = 'Y') then
7553:
7554: if l_flag = 'Y' and l_first_fps_prepay_asg = 'N' Then
7555: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7556: -- Insert assignment into pay_assignment_actions
7557: hr_nonrun_asact.insact ( lockingactid, asg_record.assignment_id, pactid, chunk, NULL );
7558: End if;
7559:

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

7609:
7610: if ((asg_rec.asg_act_id = l_aggr_min_act_id) and (l_earlier_processed = 0)) then
7611: hr_utility.set_location('Creating Assignment Action for assignment_id '||asg_rec.assignment_id, 50);
7612:
7613: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7614: hr_nonrun_asact.insact ( lockingactid, asg_rec.assignment_id, pactid, chunk, NULL );
7615: -- get the assigment action id of the prepayment payroll action id for the current assignment.
7616: OPEN csr_prepay_asg_act_details(asg_rec.assignment_id, l_pre_pact_id);
7617: FETCH csr_prepay_asg_act_details

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

7626: hr_utility.set_location('Creating other Assignment Action ids for assignment_id '||asg_rec.assignment_id, 50);
7627:
7628: /*for c_asg in csr_get_other_asg(asg_rec.assignment_id)
7629: loop*/
7630: /* SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7631: hr_utility.set_location('Creating action for asg '||c_asg.asg_id, 50);
7632: hr_nonrun_asact.insact(lockingactid, c_asg.asg_id, pactid, chunk, NULL );
7633: hr_utility.set_location('Created action for asg '||c_asg.asg_id, 50);*/
7634:

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

7642: FETCH csr_agg_all_asg_act_creat
7643: INTO l_asg_id;
7644:
7645: EXIT WHEN csr_agg_all_asg_act_creat%NOTFOUND;
7646: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7647: hr_utility.set_location('Creating action for asg '||l_asg_id, 50);
7648: hr_nonrun_asact.insact(lockingactid, l_asg_id, pactid, chunk, NULL );
7649: hr_utility.set_location('Created action for asg '||l_asg_id, 50);
7650:

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

7687:
7688: ELSIF l_flag1 = 'Y' THEN
7689: -- Create one assignment action for every assignment
7690: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);
7691: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7692:
7693: -- Insert assignment into pay_assignment_actions
7694: hr_nonrun_asact.insact ( lockingactid, asg_rec.assignment_id, pactid, chunk, NULL );
7695: -- get the assigment action id of the prepayment payroll action id for the current assignment.

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

7731: FETCH csr_ni_aggr_max_act_id INTO l_ni_aggr_max_act_id;
7732: CLOSE csr_ni_aggr_max_act_id;
7733:
7734: if nvl(l_rti_ni_proc_flag,'N') <> 'Y' and asg_rec.asg_act_id = l_ni_aggr_max_act_id then
7735: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
7736: -- Insert assignment into pay_assignment_actions
7737: hr_nonrun_asact.insact ( lockingactid, l_ni_rpt_asg_id, pactid, chunk, NULL );
7738: /* -- get the assigment action id of the prepayment payroll action id for the current assignment.
7739: OPEN csr_ni_prepay_asg_act_details(asg_rec.asg_act_id);

Line 9096: from dual

9092: CURSOR csr_aggr_locking_asg_act_id(p_person_id NUMBER, p_action_sequence NUMBER)
9093: IS
9094: /*
9095: select null into dummy
9096: from dual
9097: where not exists
9098: (select null
9099: */
9100: SELECT min (act.assignment_action_id)