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 834: sys.dual target where exists

830:
831: --
832: cursor taxable_or_paye_exists (c_assignment_action_id in number) is
833: SELECT 'Y' FROM
834: sys.dual target where exists
835: (select 1
836: from PAY_BALANCE_FEEDS_F FEED
837: , PAY_BALANCE_TYPES PBT
838: , PAY_RUN_RESULT_VALUES PRRV

Line 870: FROM dual;

866: SELECT to_date('06-04-'||
867: to_char(fnd_number.canonical_to_number(to_char(X_ASSIGNMENT_END_DATE,'YYYY'))
868: + least(sign(X_ASSIGNMENT_END_DATE - to_date('06-04-'
869: || to_char(X_ASSIGNMENT_END_DATE,'YYYY'),'DD-MM-YYYY')),0)),'DD-MM-YYYY')
870: FROM dual;
871: --
872: CURSOR csr_get_action_tax_year_start (p_asg_action_id NUMBER) IS
873: SELECT to_date('06-04-'||
874: to_char(fnd_number.canonical_to_number(to_char(ptp.regular_payment_date,'YYYY'))

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

1602: WHEN p45_one_taxyear_error THEN
1603: sqlstr := 'select 1 '||
1604: '/* ERROR - The Start Date and the End Date must be within the tax year: '||
1605: sqlerrm(sqlcode)||' */ '||
1606: 'from dual where to_char(:payroll_action_id) = dummy';
1607: RAISE;
1608: --
1609: -- End of BUG 5671777-11
1610: --

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

1619: -- Return cursor that selects no rows
1620: sqlstr := 'select 1 '||
1621: '/* ERROR - Employer Details Fetch failed with: '||
1622: sqlerrm(sqlcode)||' */ '||
1623: 'from dual where to_char(:payroll_action_id) = dummy';
1624: hr_utility.set_location(' Leaving: '||l_proc,110);
1625: END range_cursor;
1626: ---------------------------------------------------------------------------
1627: -- Function: range_person_on.

Line 1790: select 1 from dual where exists

1786: l_number number;
1787: --
1788: cursor csr_future_assignment (c_assignment_id in number,
1789: c_effective_end_date in date) is
1790: select 1 from dual where exists
1791: (select paf.effective_end_date
1792: from per_all_assignments_f paf,
1793: per_assignment_status_types past
1794: where past.assignment_status_type_id = paf.assignment_status_type_id

Line 1827: select 1 from dual where exists

1823: --
1824: cursor csr_transfer (c_assignment_id in number,
1825: c_effective_end_date in date,
1826: c_tax_ref in varchar2) is
1827: select 1 from dual where exists
1828: (select scl.segment1
1829: from per_all_assignments_f paf,
1830: pay_all_payrolls_f ppf,
1831: hr_soft_coding_keyflex scl

Line 1870: select 1 from dual where exists

1866: l_lsp_date date;
1867: --
1868: cursor csr_payment (c_assignment_id in number,
1869: c_effective_end_date in date) is
1870: select 1 from dual where exists
1871: (select pa.effective_date
1872: from pay_payroll_actions pa,
1873: pay_assignment_actions aa
1874: where aa.assignment_id = c_assignment_id

Line 1887: select 1 from dual where exists

1883: --
1884: cursor csr_lsp_payment(c_last_process_date in date,
1885: c_effective_end_date in date,
1886: c_assignment_id in number) is
1887: select 1 from dual where exists
1888: (select paa.assignment_action_id
1889: from pay_assignment_actions paa,
1890: pay_payroll_actions ppa,
1891: per_time_periods ptp

Line 1958: select 1 from dual where exists

1954: l_number number;
1955: l_manual_issue_exists BOOLEAN;
1956: --
1957: cursor csr_manual_date (c_assignment_id in number) is
1958: select 1 from dual where exists
1959: (select aei.aei_information3
1960: from per_assignment_extra_info aei
1961: where aei.assignment_id = c_assignment_id
1962: and aei.aei_information3 is not null

Line 2005: select 1 from dual where exists

2001: AND ppa.action_type in ('R', 'Q', 'I', 'V', 'B');
2002: --
2003: cursor csr_tax_code_ni (c_assignment_action_id in number,
2004: c_effective_end_date in date) is
2005: select 1 from dual where exists
2006: (select prrv.result_value
2007: from pay_input_values_f inv,
2008: pay_element_types_f type,
2009: pay_run_results prr,

Line 2538: FROM dual;

2534: then
2535: hr_utility.trace('ARCHIVING FOR '||to_char(rec_asg.assignment_id));
2536: SELECT pay_assignment_actions_s.nextval
2537: INTO l_actid
2538: FROM dual;
2539: --
2540: hr_utility.set_location(l_proc,110);
2541: hr_nonrun_asact.insact(l_actid,rec_asg.assignment_id,
2542: pactid,chunk,NULL);

Line 3389: select 1 from dual where exists

3385: WHERE fcr.request_id = pact.request_id
3386: AND pact.payroll_action_id = p_payroll_action_id;
3387: --
3388: cursor get_errored_actions(c_payroll_action_id number) is
3389: select 1 from dual where exists
3390: (select action_status
3391: from pay_assignment_actions
3392: where payroll_action_id = c_payroll_action_id
3393: and action_status = 'E');

Line 3679: FROM dual;

3675: --
3676: hr_utility.set_location(l_proc,25);
3677: SELECT pay_assignment_actions_s.nextval
3678: INTO l_actid
3679: FROM dual;
3680: --
3681: hr_utility.set_location(l_proc,27);
3682: hr_nonrun_asact.insact(l_actid,rec_asg.assignment_id,
3683: pactid,chunk,NULL);

Line 3698: FROM dual;

3694: FOR rec_asg IN csr_assignments LOOP
3695: --
3696: SELECT pay_assignment_actions_s.nextval
3697: INTO l_actid
3698: FROM dual;
3699: --
3700: hr_nonrun_asact.insact(l_actid,rec_asg.assignment_id,
3701: pactid,chunk,NULL);
3702: -- Interlock the archive action