[Home] [Help]
32: having the payroll action id */
33: SELECT PTP.end_date+1
34: INTO l_next_to_end_date
35: FROM per_time_periods ptp,
36: pay_payroll_actions pact
37: WHERE pact.payroll_action_id = p_payroll_action_id
38: AND pact.payroll_id = ptp.payroll_id
39: AND p_given_date between ptp.start_date and ptp.end_date;
40:
91: --------------------------------------------------------------------------------
92: is
93: cursor csr_expiry_information is
94: select 1
95: from pay_payroll_actions ppa2,
96: pay_payroll_actions ppa1
97: where ppa1.payroll_action_id = p_owner_payroll_action_id
98: and ppa2.payroll_action_id = p_user_payroll_action_id
99: and ppa2.time_period_id <> ppa1.time_period_id;
92: is
93: cursor csr_expiry_information is
94: select 1
95: from pay_payroll_actions ppa2,
96: pay_payroll_actions ppa1
97: where ppa1.payroll_action_id = p_owner_payroll_action_id
98: and ppa2.payroll_action_id = p_user_payroll_action_id
99: and ppa2.time_period_id <> ppa1.time_period_id;
100: begin
243: l_fiscal_year_start_date date;
244: cursor csr_fiscal_year_start_date is
245: select fnd_date.canonical_to_date(hoi.org_information11)
246: from hr_organization_information hoi,
247: pay_payroll_actions ppa
248: where ppa.payroll_action_id = p_payroll_action_id
249: and hoi.organization_id = ppa.business_group_id
250: and hoi.org_information_context = 'Business Group Information';
251: begin
495: l_run_type_name pay_run_types_f.run_type_name%TYPE;
496: cursor csr_run_type_name is
497: select prt.run_type_name
498: from pay_run_types_f prt,
499: pay_payroll_actions ppa
500: where ppa.payroll_action_id = p_payroll_action_id
501: and prt.run_type_id = ppa.run_type_id
502: and ppa.effective_date
503: between prt.effective_start_date and prt.effective_end_date;
505: cursor csr_run_type_name_assact is
506: select prt.run_type_name
507: from pay_run_types_f prt,
508: pay_assignment_actions paa,
509: pay_payroll_actions ppa
510: where paa.assignment_action_id = p_assact_id
511: and ppa.payroll_action_id = p_payroll_action_id
512: and prt.run_type_id = paa.run_type_id
513: and ppa.effective_date
678: ppa.assignment_set_id,
679: ptp.start_date
680: from pay_run_types_f prt,
681: per_time_periods ptp,
682: pay_payroll_actions ppa
683: where ppa.payroll_id = p_payroll_id
684: and ppa.action_type = 'R'
685: and ppa.effective_date
686: between l_soy and p_effective_date
767: select
768: fnd_date.canonical_to_date(prrv.result_value)
769: from pay_run_result_values prrv,
770: pay_run_results prr,
771: pay_payroll_actions ppa,
772: pay_assignment_actions paa,
773: pay_element_types_f pet,
774: pay_input_values_f piv
775: where
790: select
791: min(greatest(ptp.start_date, trunc(ppa1.effective_date, 'YYYY')))
792: from per_time_periods ptp,
793: pay_run_types_f prt2,
794: pay_payroll_actions ppa2,
795: pay_assignment_actions paa2,
796: pay_run_types_f prt1,
797: pay_payroll_actions ppa1,
798: pay_assignment_actions paa1
793: pay_run_types_f prt2,
794: pay_payroll_actions ppa2,
795: pay_assignment_actions paa2,
796: pay_run_types_f prt1,
797: pay_payroll_actions ppa1,
798: pay_assignment_actions paa1
799: where paa1.assignment_action_id = p_assignment_action_id
800: and ppa1.payroll_action_id = paa1.payroll_action_id
801: and prt1.run_type_id = paa1.run_type_id
816: and paa2.action_sequence > (
817: /* Latest bonus with same run_type category as corrent bonus. */
818: select nvl(max(paa3.action_sequence), 0)
819: from pay_run_types_f prt3,
820: pay_payroll_actions ppa3,
821: pay_assignment_actions paa3
822: where paa3.assignment_id = paa1.assignment_id
823: and paa3.action_sequence < paa1.action_sequence
824: and ppa3.payroll_action_id = paa3.payroll_action_id