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

Line 214: from sys.dual) ;

210: to_char(nvl(l_organization_id,l_parent_id))
211: and pose.org_structure_version_id =
212: to_char(l_org_structure_version_id)
213: union select to_char(nvl(l_organization_id,l_parent_id))
214: from sys.dual) ;
215: cursor csr_condition_two(l_organization_id number , l_effective_date date) is
216: SELECT distinct pai_emp.action_information15 organization
217: ,ppf.payroll_id
218: FROM per_time_periods ptp

Line 291: from sys.dual) ;

287: to_char(nvl(l_organization_id,l_parent_id))
288: and pose.org_structure_version_id =
289: to_char(l_org_structure_version_id)
290: union select to_char(nvl(l_organization_id,l_parent_id))
291: from sys.dual) ;
292: /* CURSOR TO GET PAYROLL IDS DISTINCT FOR ORGANIZATION */
293: cursor csr_org_only_distinct_pyrl(l_organization_id number , l_effective_date date) is
294: SELECT distinct ppf.payroll_id
295: FROM per_time_periods ptp

Line 323: union select to_char(nvl(l_organization_id,l_parent_id)) from sys.dual;

319: prior pose.organization_id_child
320: and pose.org_structure_version_id = to_char (l_org_structure_version_id)
321: start with pose.organization_id_parent = to_char(nvl(l_organization_id,l_parent_id))
322: and pose.org_structure_version_id = to_char(l_org_structure_version_id)
323: union select to_char(nvl(l_organization_id,l_parent_id)) from sys.dual;
324: /* SELECTS DATA FOR A GIVEN ORGANIZATION AND A PAYROLL COMBINATION */
325: CURSOR csr_get_details (l_payroll_id number , l_effective_date date, l_org_name varchar2,p_order_1 varchar2,p_order_2 varchar2,p_order_3 varchar2) Is
326: SELECT distinct pai_emp.action_context_id arch_assact
327: ,to_char(ptp.payroll_id) org_pay

Line 550: union select to_char(l_organization_id) from sys.dual)

546: and pose.org_structure_version_id =
547: to_char (l_org_structure_version_id)
548: start with pose.organization_id_parent = to_char(l_organization_id)
549: and pose.org_structure_version_id = to_char(l_org_structure_version_id)
550: union select to_char(l_organization_id) from sys.dual)
551: /*AND pai_emp.action_information15 = l_org_name*/
552: AND lck.locking_action_id = pai_emp.action_context_id
553: AND lck.locked_action_id = paa1.assignment_action_id
554: AND paa1.payroll_action_id = ppa1.payroll_action_id

Line 665: union select to_char(l_organization_id) from sys.dual)

661: and pose.org_structure_version_id =
662: to_char (l_org_structure_version_id)
663: start with pose.organization_id_parent = to_char(l_organization_id)
664: and pose.org_structure_version_id = to_char(l_org_structure_version_id)
665: union select to_char(l_organization_id) from sys.dual)
666: /*AND pai_emp.action_information15 = l_org_name*/
667: AND lck.locking_action_id = pai_emp.action_context_id
668: AND lck.locked_action_id = paa1.assignment_action_id
669: AND paa1.payroll_action_id = ppa1.payroll_action_id

Line 1801: select userenv('LANGUAGE') into g_nls_db_char from dual;

1797: l_blob_offset pls_integer := 1;
1798:
1799: begin
1800: hr_utility.set_location('Entered Procedure clob to blob',120);
1801: select userenv('LANGUAGE') into g_nls_db_char from dual;
1802: l_length_clob := dbms_lob.getlength(p_clob);
1803: l_offset := 1;
1804: while l_length_clob > 0 loop
1805: hr_utility.trace('l_length_clob '|| l_length_clob);