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.

[Home] [Help]

APPS.PAY_AE_PAYROLL_REGISTER dependencies on DUAL

Line 212: from sys.dual) ;

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

Line 289: from sys.dual) ;

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

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

317: prior pose.organization_id_child
318: and pose.org_structure_version_id = to_char (l_org_structure_version_id)
319: start with pose.organization_id_parent = to_char(nvl(l_organization_id,l_parent_id))
320: and pose.org_structure_version_id = to_char(l_org_structure_version_id)
321: union select to_char(nvl(l_organization_id,l_parent_id)) from sys.dual;
322: /* SELECTS DATA FOR A GIVEN ORGANIZATION AND A PAYROLL COMBINATION */
323: 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
324: SELECT distinct pai_emp.action_context_id arch_assact
325: ,to_char(ptp.payroll_id) org_pay

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

516: and pose.org_structure_version_id =
517: to_char (l_org_structure_version_id)
518: start with pose.organization_id_parent = to_char(l_organization_id)
519: and pose.org_structure_version_id = to_char(l_org_structure_version_id)
520: union select to_char(l_organization_id) from sys.dual)
521: AND lck.locking_action_id = pai_emp.action_context_id
522: AND lck.locked_action_id = paa1.assignment_action_id
523: AND paa1.payroll_action_id = ppa1.payroll_action_id
524: AND ptp.payroll_id = ppa1.payroll_id

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

555: and pose.org_structure_version_id =
556: to_char (l_org_structure_version_id)
557: start with pose.organization_id_parent = to_char(l_organization_id)
558: and pose.org_structure_version_id = to_char(l_org_structure_version_id)
559: union select to_char(l_organization_id) from sys.dual)
560: AND lck.locking_action_id = pai_emp.action_context_id
561: AND lck.locked_action_id = paa1.assignment_action_id
562: AND paa1.payroll_action_id = ppa1.payroll_action_id
563: AND ptp.payroll_id = ppa1.payroll_id

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

713: and pose.org_structure_version_id =
714: to_char (l_org_structure_version_id)
715: start with pose.organization_id_parent = to_char(l_organization_id)
716: and pose.org_structure_version_id = to_char(l_org_structure_version_id)
717: union select to_char(l_organization_id) from sys.dual)
718: AND lck.locking_action_id = pai_emp.action_context_id
719: AND lck.locked_action_id = paa1.assignment_action_id
720: AND paa1.payroll_action_id = ppa1.payroll_action_id
721: AND ptp.payroll_id = ppa1.payroll_id

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

752: and pose.org_structure_version_id =
753: to_char (l_org_structure_version_id)
754: start with pose.organization_id_parent = to_char(l_organization_id)
755: and pose.org_structure_version_id = to_char(l_org_structure_version_id)
756: union select to_char(l_organization_id) from sys.dual)
757: AND lck.locking_action_id = pai_emp.action_context_id
758: AND lck.locked_action_id = paa1.assignment_action_id
759: AND paa1.payroll_action_id = ppa1.payroll_action_id
760: AND ptp.payroll_id = ppa1.payroll_id

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

1907: l_raw_buffer_len pls_integer;
1908: l_blob_offset pls_integer := 1;
1909: begin
1910: hr_utility.set_location('Entered Procedure clob to blob',120);
1911: select userenv('LANGUAGE') into g_nls_db_char from dual;
1912: l_length_clob := dbms_lob.getlength(p_clob);
1913: l_offset := 1;
1914: while l_length_clob > 0 loop
1915: hr_utility.trace('l_length_clob '|| l_length_clob);