[Home] [Help]
734: and asg.payroll_id + 0 = p_payroll_id));
735: --
736: cursor csr_valid_payroll (p_date date) is
737: select 'Y'
738: from sys.dual
739: where not exists
740: (select null
741: from per_all_assignments_f asg
742: where asg.assignment_id = p_assignment_id
794: --
795: begin
796: select 'Y'
797: into v_check_failed
798: from sys.dual
799: where exists
800: (select null
801: from pay_payrolls_f pay
802: where pay.payroll_id = p_payroll_id
828: --
829: -- begin
830: -- select 'Y'
831: -- into v_check_failed
832: -- from sys.dual
833: -- where exists
834: -- (select null
835: -- from pay_assignment_actions aa,
836: -- pay_payroll_actions pa
879: --
880: -- begin
881: -- select 'Y'
882: -- into v_check_failed
883: -- from sys.dual
884: -- where exists
885: -- (select null
886: -- from pay_assignment_actions aa,
887: -- pay_payroll_actions pa
1253: --
1254: begin
1255: select 'Y'
1256: into v_entry_overridden
1257: from sys.dual
1258: where exists
1259: (select null
1260: from pay_element_entries_f ee
1261: where ee.assignment_id = p_assignment_id
2390: hr_utility.trace('Before:l_original_entry_id: '||l_original_entry_id);
2391: begin
2392: select 1
2393: into v_original_entry_exists
2394: from sys.dual
2395: where exists
2396: (select null
2397: from pay_element_entries_f ee
2398: ,pay_element_links_f el
3632: /*Bug 9710104 Checking if assignment exists if not then its purged */
3633: Begin
3634: select 1
3635: into lv_asg_exists
3636: from dual
3637: where exists (select 1
3638: from per_all_assignments_f
3639: where assignment_id =p_assignment_id);
3640: Exception when no_data_found then
4317: )
4318: is
4319: cursor csr_cae is
4320: select null
4321: from dual
4322: where exists
4323: (select null
4324: from pay_element_entries_f pee,
4325: per_time_periods ptp
4733: and ee.effective_start_date <= p_entry_end_date
4734: and ee.effective_end_date >= p_entry_start_date
4735: UNION ALL
4736: select to_number(null)
4737: from sys.dual
4738: where p_mult_ent_allowed_flag = 'N'
4739: and exists
4740: (select null
4741: from pay_element_entries_f ee
7863: --
7864: begin
7865: select 'Y'
7866: into no_opmu
7867: from sys.dual
7868: where exists
7869: (select null
7870: from pay_personal_payment_methods_f ppm
7871: where assignment_id = p_assignment_id
7895: --
7896: begin
7897: select 'Y'
7898: into no_opmu
7899: from sys.dual
7900: where not exists
7901: (select null
7902: from pay_org_pay_method_usages_f opmu,
7903: pay_payrolls_f p
7928: --
7929: begin
7930: select 'Y'
7931: into no_opmu
7932: from sys.dual
7933: where exists
7934: (select null
7935: from pay_org_pay_method_usages_f opmu,
7936: pay_payrolls_f p