[Home] [Help]
526: sum(decode(trunc(spact.effective_date,'YYYY'),c_start_yr2,fnd_number.canonical_to_number(TARGET.result_value))) pymt_yr2
527: from pay_run_result_values TARGET
528: , pay_balance_feeds_f FEED
529: , pay_run_results RR
530: , pay_assignment_actions ASSACT
531: , pay_payroll_actions PACT
532: , pay_balance_types bal
533: --
534: , pay_assignment_actions sasact
530: , pay_assignment_actions ASSACT
531: , pay_payroll_actions PACT
532: , pay_balance_types bal
533: --
534: , pay_assignment_actions sasact
535: , pay_payroll_actions spact
536: , pay_entry_process_details proc
537: where ASSACT.assignment_id = P_Assignment_id
538: and BAL.balance_name = c_balance_name
550: and PACT.action_type <> 'V'
551: and NOT EXISTS
552: (SELECT NULL
553: FROM pay_payroll_actions RPACT
554: , pay_assignment_actions RASSACT
555: , pay_action_interlocks RINTLK
556: where ASSACT.assignment_action_id = RINTLK.locked_action_id
557: and RINTLK.locking_action_id = RASSACT.assignment_action_id
558: and RPACT.payroll_action_id = RASSACT.payroll_action_id
2098: c_period Date) Is
2099: -- AS 5/9/3 commented out some date and status criteria here as error was being raised incorrectly
2100: Select 'Y'
2101: from pay_payroll_actions ppa
2102: ,pay_assignment_actions paa
2103: ,pay_run_results prr
2104: where ppa.payroll_id + 0 = p_asg.payroll_id
2105: -- and ppa.date_earned < trunc(p_sickness_start_date,'MONTH')
2106: -- and to_char(ppa.date_earned,'MON-YYYY') = to_char(c_period,'MON-YYYY')
2126: pay_input_values_f piv_pet,
2127: pay_run_results prr_pst,
2128: pay_run_results prr_pet,
2129: pay_element_types_f peltf,
2130: pay_assignment_actions pact,
2131: pay_payroll_actions ppac
2132: --
2133: Where prrv_pst.result_value between fnd_date.date_to_canonical(c_abs_start_date) and fnd_date.date_to_canonical(c_abs_end_date)
2134: and prrv_pet.result_value between fnd_date.date_to_canonical(c_abs_start_date) and fnd_date.date_to_canonical(c_abs_end_date)
2680: g_gi_info_best_method_iv_id,target.result_value,
2681: g_gi_i_r_best_method_iv_id, target.result_value,null)) best_method,
2682: nvl(ee.creator_id,0) retro_asg_action,
2683: epd.adjustment_type retro_adj_type
2684: from pay_assignment_actions assact
2685: ,pay_payroll_actions pact
2686: ,pay_run_results rr
2687: ,pay_run_result_values guarantee_id
2688: ,pay_run_result_values parent_absence_id
2724: and guarantee_id.result_value = p_guarantee_id
2725: and NOT EXISTS
2726: (SELECT 1
2727: FROM pay_payroll_actions RPACT
2728: , pay_assignment_actions RASSACT
2729: , pay_action_interlocks RINTLK
2730: where ASSACT.assignment_action_id = RINTLK.locked_action_id
2731: and RINTLK.locking_action_id = RASSACT.assignment_action_id
2732: and RPACT.payroll_action_id = RASSACT.payroll_action_id
2846: ,l_overlap_band1_days
2847: ,l_overlap_band2_days
2848: ,l_overlap_band3_days
2849: ,l_overlap_band4_days
2850: from pay_assignment_actions assact,
2851: pay_payroll_actions pact,
2852: pay_run_results rr,
2853: pay_run_result_values rrv_end,
2854: pay_run_result_values rrv_start,
2988: g_gi_i_r_band3_iv_id, target.result_value,0)),0)
2989: ,nvl(sum(decode(target.input_value_id,
2990: g_gi_info_band4_iv_id,target.result_value,
2991: g_gi_i_r_band4_iv_id, target.result_value,0)),0)
2992: from pay_assignment_actions assact
2993: ,pay_payroll_actions pact
2994: ,pay_run_results rr
2995: ,pay_run_result_values guarantee_id
2996: ,pay_run_result_values payment_date