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

Line 912: sys.dual target where exists

908:
909: --
910: cursor taxable_or_paye_exists (c_assignment_action_id in number) is
911: SELECT 'Y' FROM
912: sys.dual target where exists
913: (select 1
914: from PAY_BALANCE_FEEDS_F FEED
915: , PAY_BALANCE_TYPES PBT
916: , PAY_RUN_RESULT_VALUES PRRV

Line 948: FROM dual;

944: SELECT to_date('06-04-'||
945: to_char(fnd_number.canonical_to_number(to_char(X_ASSIGNMENT_END_DATE,'YYYY'))
946: + least(sign(X_ASSIGNMENT_END_DATE - to_date('06-04-'
947: || to_char(X_ASSIGNMENT_END_DATE,'YYYY'),'DD-MM-YYYY')),0)),'DD-MM-YYYY')
948: FROM dual;
949: --
950: CURSOR csr_get_action_tax_year_start (p_asg_action_id NUMBER) IS
951: SELECT to_date('06-04-'||
952: to_char(fnd_number.canonical_to_number(to_char(ptp.regular_payment_date,'YYYY'))

Line 1723: 'from dual where to_char(:payroll_action_id) = dummy';

1719: WHEN p45_one_taxyear_error THEN
1720: sqlstr := 'select 1 '||
1721: '/* ERROR - The Start Date and the End Date must be within the tax year: '||
1722: sqlerrm(sqlcode)||' */ '||
1723: 'from dual where to_char(:payroll_action_id) = dummy';
1724: RAISE;
1725: --
1726: -- End of BUG 5671777-11
1727: --

Line 1740: 'from dual where to_char(:payroll_action_id) = dummy';

1736: -- Return cursor that selects no rows
1737: sqlstr := 'select 1 '||
1738: '/* ERROR - Employer Details Fetch failed with: '||
1739: sqlerrm(sqlcode)||' */ '||
1740: 'from dual where to_char(:payroll_action_id) = dummy';
1741: hr_utility.set_location(' Leaving: '||l_proc,110);
1742: END range_cursor;
1743: ---------------------------------------------------------------------------
1744: -- Function: range_person_on.

Line 1907: select 1 from dual where exists

1903: l_number number;
1904: --
1905: cursor csr_future_assignment (c_assignment_id in number,
1906: c_effective_end_date in date) is
1907: select 1 from dual where exists
1908: (select paf.effective_end_date
1909: from per_all_assignments_f paf,
1910: per_assignment_status_types past
1911: where past.assignment_status_type_id = paf.assignment_status_type_id

Line 1946: select 1 from dual where exists

1942: --
1943: cursor csr_transfer (c_assignment_id in number,
1944: c_effective_end_date in date,
1945: c_tax_ref in varchar2) is
1946: select 1 from dual where exists
1947: (select scl.segment1
1948: from per_all_assignments_f paf,
1949: pay_all_payrolls_f ppf,
1950: hr_soft_coding_keyflex scl

Line 1992: select 1 from dual where exists

1988: l_lsp_date date;
1989: --
1990: cursor csr_payment (c_assignment_id in number,
1991: c_effective_end_date in date) is
1992: select 1 from dual where exists
1993: (select pa.effective_date
1994: from pay_payroll_actions pa,
1995: pay_assignment_actions aa
1996: where aa.assignment_id = c_assignment_id

Line 2009: select 1 from dual where exists

2005: --
2006: cursor csr_lsp_payment(c_last_process_date in date,
2007: c_effective_end_date in date,
2008: c_assignment_id in number) is
2009: select 1 from dual where exists
2010: (select paa.assignment_action_id
2011: from pay_assignment_actions paa,
2012: pay_payroll_actions ppa,
2013: per_time_periods ptp

Line 2080: select 1 from dual where exists

2076: l_number number;
2077: l_manual_issue_exists BOOLEAN;
2078: --
2079: cursor csr_manual_date (c_assignment_id in number) is
2080: select 1 from dual where exists
2081: (select aei.aei_information3
2082: from per_assignment_extra_info aei
2083: where aei.assignment_id = c_assignment_id
2084: and aei.aei_information3 is not null

Line 2127: select 1 from dual where exists

2123: AND ppa.action_type in ('R', 'Q', 'I', 'V', 'B');
2124: --
2125: cursor csr_tax_code_ni (c_assignment_action_id in number) is
2126: -- c_effective_end_date in date) is --Bug 9036584
2127: select 1 from dual where exists
2128: (select prrv.result_value
2129: from pay_input_values_f inv,
2130: pay_element_types_f type,
2131: pay_run_results prr,

Line 2674: FROM dual;

2670: then
2671: hr_utility.trace('ARCHIVING FOR '||to_char(rec_asg.assignment_id));
2672: SELECT pay_assignment_actions_s.nextval
2673: INTO l_actid
2674: FROM dual;
2675: --
2676: hr_utility.set_location(l_proc,110);
2677: hr_nonrun_asact.insact(l_actid,rec_asg.assignment_id,
2678: pactid,chunk,NULL);

Line 4086: select 1 from dual where exists

4082: WHERE fcr.request_id = pact.request_id
4083: AND pact.payroll_action_id = p_payroll_action_id;
4084: --
4085: cursor get_errored_actions(c_payroll_action_id number) is
4086: select 1 from dual where exists
4087: (select action_status
4088: from pay_assignment_actions
4089: where payroll_action_id = c_payroll_action_id
4090: and action_status = 'E');

Line 4461: FROM dual;

4457: --
4458: hr_utility.set_location(l_proc,25);
4459: SELECT pay_assignment_actions_s.nextval
4460: INTO l_actid
4461: FROM dual;
4462: --
4463: hr_utility.set_location(l_proc,27);
4464: hr_nonrun_asact.insact(l_actid,rec_asg.assignment_id,
4465: pactid,chunk,NULL);

Line 4480: FROM dual;

4476: FOR rec_asg IN csr_assignments LOOP
4477: --
4478: SELECT pay_assignment_actions_s.nextval
4479: INTO l_actid
4480: FROM dual;
4481: --
4482: hr_nonrun_asact.insact(l_actid,rec_asg.assignment_id,
4483: pactid,chunk,NULL);
4484: -- Interlock the archive action