[Home] [Help]
599: --
600: CURSOR csr_previous_action_sequence is
601: select max(paa.action_sequence)
602: from pay_assignment_actions paa
603: ,pay_payroll_actions ppa
604: where ppa.payroll_action_id = paa.payroll_action_id
605: and paa.assignment_id = p_assignment_id
606: and p_paid_days_to >= ppa.effective_date
607: and ppa.action_type in ('Q','R');
699: --
700: CURSOR csr_current_action_sequence is
701: select min(paa.action_sequence)
702: from pay_assignment_actions paa
703: ,pay_payroll_actions ppa
704: where ppa.payroll_action_id = paa.payroll_action_id
705: and paa.assignment_id = p_assignment_id
706: and p_paid_days_to <= ppa.effective_date
707: and ppa.action_type in ('Q','R');
708:
709: CURSOR csr_previous_and_current_seq is
710: select max(paa.action_sequence)
711: from pay_assignment_actions paa
712: ,pay_payroll_actions ppa
713: where ppa.payroll_action_id = paa.payroll_action_id
714: and paa.assignment_id = p_assignment_id
715: and p_paid_days_to >= ppa.effective_date
716: and ppa.action_type in ('Q','R');
768: from pay_run_result_values prrv_days
769: ,pay_run_result_values prrv_accrual
770: ,pay_run_results prr
771: ,pay_assignment_actions paa
772: ,pay_payroll_actions ppa
773: where prrv_days.run_result_id = prr.run_result_id
774: and prrv_accrual.run_result_id = prr.run_result_id
775: and prrv_days.input_value_id = l_fr_plan_info.term_days_iv_ID
776: and prrv_accrual.input_value_id = l_fr_plan_info.term_accrual_date_iv_ID
1754: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);
1755: CURSOR csr_action_sequence_all_paid is
1756: select max(paa.action_sequence)
1757: from pay_assignment_actions paa
1758: ,pay_payroll_Actions ppa
1759: where ppa.payroll_action_id = paa.payroll_action_id
1760: and paa.assignment_id = p_assignment_id;
1761: begin
1762: hr_utility.set_location('Entering ' || l_proc,10);
2158: CURSOR csr_get_assignment_action (l_assignment_id number) is
2159: select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2160: paa.assignment_action_id),16))
2161: from pay_assignment_actions paa,
2162: pay_payroll_actions ppa
2163: where paa.assignment_id = l_assignment_id
2164: and ppa.payroll_action_id = paa.payroll_action_id
2165: and ppa.effective_date between l_fr_plan_info.accrual_year_start and l_fr_plan_info.accrual_year_end
2166: and ppa.action_type in ('R', 'Q', 'I', 'V', 'B');
2187: ,pay_balance_feeds_f FEED
2188: ,pay_run_results RR
2189: ,pay_assignment_actions ASSACT
2190: ,pay_assignment_actions BAL_ASSACT
2191: ,pay_payroll_actions PACT
2192: ,pay_payroll_actions BACT
2193: ,per_time_periods PTP
2194: where BAL_ASSACT.assignment_action_id = l_latest_aa /*B1 */
2195: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
2188: ,pay_run_results RR
2189: ,pay_assignment_actions ASSACT
2190: ,pay_assignment_actions BAL_ASSACT
2191: ,pay_payroll_actions PACT
2192: ,pay_payroll_actions BACT
2193: ,per_time_periods PTP
2194: where BAL_ASSACT.assignment_action_id = l_latest_aa /*B1 */
2195: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
2196: and FEED.balance_type_id = l_balance_type_id /*U1*/
4393: from pay_run_result_values prrvm
4394: ,pay_run_result_values prrva
4395: ,pay_run_results prr
4396: ,pay_assignment_actions paa
4397: ,pay_payroll_actions ppa
4398: where prrvm.run_result_id = prr.run_result_id
4399: and prrva.run_result_id = prr.run_result_id
4400: and prrvm.input_value_id in(l_days_input_id, l_protected_days_input_id)
4401: and prrva.input_value_id = l_absence_attendance_input_id