APPS.HRENTMNT dependencies on DUAL

Line 665: -- from dual;

661: -- insert statement.
662: --
663: -- select pay_assignment_link_usages_s.nextval
664: -- into v_alu_id_tab(v_counter)
665: -- from dual;
666: --
667: v_alu_start_date_tab(v_counter) := v_alu_start_date;
668: v_alu_end_date_tab(v_counter) := v_alu_end_date;
669: v_alu_link_id_tab(v_counter) := v_link.element_link_id;

Line 898: from sys.dual

894: and asg.payroll_id + 0 = p_payroll_id));
895: --
896: cursor csr_valid_payroll (p_date date) is
897: select 'Y'
898: from sys.dual
899: where not exists
900: (select null
901: from per_all_assignments_f asg
902: where asg.assignment_id = p_assignment_id

Line 950: from sys.dual

946: --
947: begin
948: select 'Y'
949: into v_check_failed
950: from sys.dual
951: where exists
952: (select null
953: from pay_payrolls_f pay
954: where pay.payroll_id = p_payroll_id

Line 984: -- from sys.dual

980: --
981: -- begin
982: -- select 'Y'
983: -- into v_check_failed
984: -- from sys.dual
985: -- where exists
986: -- (select null
987: -- from pay_assignment_actions aa,
988: -- pay_payroll_actions pa

Line 1023: -- from sys.dual

1019: --
1020: -- begin
1021: -- select 'Y'
1022: -- into v_check_failed
1023: -- from sys.dual
1024: -- where exists
1025: -- (select null
1026: -- from pay_assignment_actions aa,
1027: -- pay_payroll_actions pa

Line 1397: from sys.dual

1393: --
1394: begin
1395: select 'Y'
1396: into v_entry_overridden
1397: from sys.dual
1398: where exists
1399: (select null
1400: from pay_element_entries_f ee
1401: where ee.assignment_id = p_assignment_id

Line 4002: from sys.dual

3998: and ee.effective_start_date <= p_entry_end_date
3999: and ee.effective_end_date >= p_entry_start_date
4000: UNION ALL
4001: select to_number(null)
4002: from sys.dual
4003: where p_mult_ent_allowed_flag = 'N'
4004: and exists
4005: (select null
4006: from pay_element_entries_f ee

Line 6844: from sys.dual

6840: --
6841: begin
6842: select 'Y'
6843: into no_opmu
6844: from sys.dual
6845: where exists
6846: (select null
6847: from pay_personal_payment_methods_f ppm
6848: where assignment_id = p_assignment_id

Line 6876: from sys.dual

6872: --
6873: begin
6874: select 'Y'
6875: into no_opmu
6876: from sys.dual
6877: where not exists
6878: (select null
6879: from pay_org_pay_method_usages_f opmu,
6880: pay_payrolls_f p

Line 6909: from sys.dual

6905: --
6906: begin
6907: select 'Y'
6908: into no_opmu
6909: from sys.dual
6910: where exists
6911: (select null
6912: from pay_org_pay_method_usages_f opmu,
6913: pay_payrolls_f p