APPS.PAY_AE_PAYROLL_REGISTER dependencies on DUAL

Line 237: from sys.dual) ; */

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

Line 269: from sys.dual) ;

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

Line 344: FROM dual

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

Line 379: from sys.dual) ; */

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

Line 410: from sys.dual) ;

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

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

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

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

681: and pose.org_structure_version_id =
682: to_char (l_org_structure_version_id)
683: start with pose.organization_id_parent = to_char(l_organization_id)
684: and pose.org_structure_version_id = to_char(l_org_structure_version_id)
685: union select to_char(l_organization_id) from sys.dual)
686: AND lck.locking_action_id = pai_emp.action_context_id
687: AND lck.locked_action_id = paa1.assignment_action_id
688: AND paa1.payroll_action_id = ppa1.payroll_action_id
689: AND ptp.payroll_id = ppa1.payroll_id

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

720: and pose.org_structure_version_id =
721: to_char (l_org_structure_version_id)
722: start with pose.organization_id_parent = to_char(l_organization_id)
723: and pose.org_structure_version_id = to_char(l_org_structure_version_id)
724: union select to_char(l_organization_id) from sys.dual)
725: AND lck.locking_action_id = pai_emp.action_context_id
726: AND lck.locked_action_id = paa1.assignment_action_id
727: AND paa1.payroll_action_id = ppa1.payroll_action_id
728: AND ptp.payroll_id = ppa1.payroll_id

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

878: and pose.org_structure_version_id =
879: to_char (l_org_structure_version_id)
880: start with pose.organization_id_parent = to_char(l_organization_id)
881: and pose.org_structure_version_id = to_char(l_org_structure_version_id)
882: union select to_char(l_organization_id) from sys.dual)
883: AND lck.locking_action_id = pai_emp.action_context_id
884: AND lck.locked_action_id = paa1.assignment_action_id
885: AND paa1.payroll_action_id = ppa1.payroll_action_id
886: AND ptp.payroll_id = ppa1.payroll_id

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

917: and pose.org_structure_version_id =
918: to_char (l_org_structure_version_id)
919: start with pose.organization_id_parent = to_char(l_organization_id)
920: and pose.org_structure_version_id = to_char(l_org_structure_version_id)
921: union select to_char(l_organization_id) from sys.dual)
922: AND lck.locking_action_id = pai_emp.action_context_id
923: AND lck.locked_action_id = paa1.assignment_action_id
924: AND paa1.payroll_action_id = ppa1.payroll_action_id
925: AND ptp.payroll_id = ppa1.payroll_id

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

2072: l_raw_buffer_len pls_integer;
2073: l_blob_offset pls_integer := 1;
2074: begin
2075: hr_utility.set_location('Entered Procedure clob to blob',120);
2076: select userenv('LANGUAGE') into g_nls_db_char from dual;
2077: l_length_clob := dbms_lob.getlength(p_clob);
2078: l_offset := 1;
2079: while l_length_clob > 0 loop
2080: hr_utility.trace('l_length_clob '|| l_length_clob);