[Home] [Help]
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
535: , pay_payroll_actions spact
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
539: and BAL.balance_type_id = FEED.balance_type_id
549: and RR.status in ('P','PA')
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
2097: c_assignment_id Number,
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')
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)
2135: --
2293: ,c_payment_start_date date
2294: ,c_payment_end_date date) is
2295: select PTP.start_date,
2296: PTP.end_date
2297: from pay_payroll_actions PPA,
2298: per_time_periods PTP
2299: where ppa.payroll_action_id = c_payroll_action_id
2300: and ppa.business_group_id = c_business_group_id
2301: and ppa.payroll_id = c_payroll_id
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
2689: ,pay_run_result_values target
2723: g_gi_i_r_guarantee_id_iv_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
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,
2855: pay_run_result_values rrv_guarantee,
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
2997: ,pay_run_result_values target