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 238: from sys.dual) ; */

234: to_char(nvl(l_organization_id,l_parent_id))
235: and pose.org_structure_version_id =
236: to_char(l_org_structure_version_id)
237: union select to_char(nvl(l_organization_id,l_parent_id))
238: from sys.dual) ; */
239: cursor csr_condition_one(l_organization_id number ,l_org_structure_version_id number,l_parent_id number, l_effective_date date ) is
240: SELECT distinct pai_emp.action_information15 organization
241: ,ppf.payroll_id
242: FROM per_time_periods ptp

Line 270: from sys.dual) ;

266: to_char(nvl(l_organization_id,l_parent_id))
267: and pose.org_structure_version_id =
268: to_char(l_org_structure_version_id)
269: union select to_char(nvl(l_organization_id,l_parent_id))
270: from sys.dual) ;
271: /* Modifyig the cursor for performance issue for Bug 7632337 */
272: /*cursor csr_condition_two(l_organization_id number , l_effective_date date) is
273: SELECT distinct pai_emp.action_information15 organization
274: ,ppf.payroll_id

Line 342: FROM dual

338: AND 1 = 2; */
339: cursor csr_condition_three(l_effective_date date) is
340: SELECT '123' organization
341: ,'213' payroll_id
342: FROM dual
343: where 1 = 2;
344: /* CURSOR TO GET PAYROLL IDS DISTINCT */
345: /* Modifyig the cursor for performance issue for Bug 7632337 */
346: /*cursor csr_distinct_pyrl(l_organization_id number ,l_org_structure_version_id number,l_parent_id number, l_effective_date date ) is

Line 377: from sys.dual) ; */

373: to_char(nvl(l_organization_id,l_parent_id))
374: and pose.org_structure_version_id =
375: to_char(l_org_structure_version_id)
376: union select to_char(nvl(l_organization_id,l_parent_id))
377: from sys.dual) ; */
378: cursor csr_distinct_pyrl(l_organization_id number ,l_org_structure_version_id number,l_parent_id number, l_effective_date date ) is
379: SELECT distinct ppf.payroll_id
380: FROM per_time_periods ptp
381: ,pay_action_information pai_emp

Line 408: from sys.dual) ;

404: to_char(nvl(l_organization_id,l_parent_id))
405: and pose.org_structure_version_id =
406: to_char(l_org_structure_version_id)
407: union select to_char(nvl(l_organization_id,l_parent_id))
408: from sys.dual) ;
409: /* CURSOR TO GET PAYROLL IDS DISTINCT FOR ORGANIZATION */
410: cursor csr_org_only_distinct_pyrl(l_organization_id number , l_effective_date date) is
411: SELECT distinct ppf.payroll_id
412: FROM per_time_periods ptp

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

436: prior pose.organization_id_child
437: and pose.org_structure_version_id = to_char (l_org_structure_version_id)
438: start with pose.organization_id_parent = to_char(nvl(l_organization_id,l_parent_id))
439: and pose.org_structure_version_id = to_char(l_org_structure_version_id)
440: union select to_char(nvl(l_organization_id,l_parent_id)) from sys.dual;
441: /* SELECTS DATA FOR A GIVEN ORGANIZATION AND A PAYROLL COMBINATION */
442: /* Modifyig the cursor for performance issue for Bug 7632337 */
443: /*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
444: SELECT distinct pai_emp.action_context_id arch_assact

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

707: and pose.org_structure_version_id =
708: to_char (l_org_structure_version_id)
709: start with pose.organization_id_parent = to_char(l_organization_id)
710: and pose.org_structure_version_id = to_char(l_org_structure_version_id)
711: union select to_char(l_organization_id) from sys.dual)
712: /*AND pai_emp.action_information15 = l_org_name*/
713: AND lck.locking_action_id = pai_emp.action_context_id
714: AND lck.locked_action_id = paa1.assignment_action_id
715: AND paa1.payroll_action_id = ppa1.payroll_action_id

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

822: and pose.org_structure_version_id =
823: to_char (l_org_structure_version_id)
824: start with pose.organization_id_parent = to_char(l_organization_id)
825: and pose.org_structure_version_id = to_char(l_org_structure_version_id)
826: union select to_char(l_organization_id) from sys.dual)
827: /*AND pai_emp.action_information15 = l_org_name*/
828: AND lck.locking_action_id = pai_emp.action_context_id
829: AND lck.locked_action_id = paa1.assignment_action_id
830: AND paa1.payroll_action_id = ppa1.payroll_action_id

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

1958: l_blob_offset pls_integer := 1;
1959:
1960: begin
1961: hr_utility.set_location('Entered Procedure clob to blob',120);
1962: select userenv('LANGUAGE') into g_nls_db_char from dual;
1963: l_length_clob := dbms_lob.getlength(p_clob);
1964: l_offset := 1;
1965: while l_length_clob > 0 loop
1966: hr_utility.trace('l_length_clob '|| l_length_clob);