[Home] [Help]
316: -- IN : --
317: -- --
318: --------------------------------------------------------------------------
319: FUNCTION get_house_rent_info_entry_id
320: (p_assact in pay_assignment_actions.assignment_Action_id%type,
321: p_effective_date in date,
322: p_year_start in date,
323: p_year_end in date,
324: p_entry_id_type_flag out nocopy varchar2 ,
341: from pay_element_types_f pet
342: ,pay_input_values_f piv
343: ,pay_element_entries_f pee
344: ,pay_element_entry_values_f pev
345: ,pay_assignment_actions pac
346: where pet.element_name ='House Rent Information'
347: and piv.name = 'JAN'
348: and pet.legislation_code ='IN'
349: and pet.element_type_id = piv.element_type_id
361: from pay_element_types_f pet
362: ,pay_input_values_f piv
363: ,pay_element_entries_f pee
364: ,pay_element_entry_values_f pev
365: ,pay_assignment_actions pac
366: where pet.element_name ='House Rent Information'
367: and piv.name = 'JAN'
368: and pet.legislation_code ='IN'
369: and pet.element_type_id = piv.element_type_id
503: p_effective_date in date ,
504: p_entry_type_flag in varchar2,
505: p_entry_end_date in date ,
506: p_payroll_id in pay_all_payrolls_f.payroll_id%type,
507: p_assact_id in pay_assignment_actions.assignment_Action_id%type,
508: p_rent_paid out nocopy t_rent_paid,
509: p_month out nocopy t_month )
510: is
511:
514: from pay_element_types_f pet
515: ,pay_input_values_f piv
516: ,pay_element_entries_f pee
517: ,pay_element_entry_values_f pev
518: ,pay_assignment_actions pac
519: where pet.element_name ='House Rent Information'
520: and piv.name = 'JAN'
521: and pet.legislation_code ='IN'
522: and pet.element_type_id = piv.element_type_id
807: /*Bug:3907894 Added ppa.effective_date in the select statement and fetched it in the table l_eff_date_tbl */
808: select paa.assignment_action_id,pay_in_tax_utils.get_period_number(ppa.payroll_id,ppa.date_earned),ppa.date_earned
809: bulk collect into l_assact_tbl,l_month_number_tbl,l_eff_date_tbl
810: from pay_payroll_Actions ppa,
811: pay_assignment_Actions paa,
812: per_assignments_f asg -- Added to remove NMV as per bug 4774108
813: where ppa.payroll_Action_id = paa.payroll_Action_id
814: and paa.assignment_id = p_assignment_id
815: and paa.assignment_id = asg.assignment_id-- Added to remove NMV as per bug 4774108
818: -- and paa.source_action_id is not null -- Commented for bug 4774514
819: and ppa.date_earned between p_year_start and p_year_end
820: and ppa.date_earned between asg.effective_start_date and asg.effective_end_date
821: and paa.action_sequence = ( select max(pac.action_sequence)
822: from pay_assignment_actions pac
823: ,pay_payroll_actions ppa1
824: where pac.assignment_id = paa.assignment_id
825: and pac.payroll_action_id = ppa1.payroll_action_id
826: and ppa1.date_earned between p_year_start and p_year_end
1208: --
1209:
1210: SELECT assignment_id
1211: INTO l_assignment_id
1212: FROM pay_assignment_actions
1213: WHERE assignment_action_id = p_assact_id ;
1214:
1215: -- Get the termination date of the employee
1216: SELECT SERVICE.actual_termination_date
2449: from pay_element_entries_f pee,
2450: pay_element_entry_values_f pev,
2451: pay_input_values_f piv,
2452: pay_element_types_f pet
2453: ,pay_assignment_actions paa
2454: where pev.element_entry_id = pee.element_entry_id
2455: and pee.element_type_id = piv.element_type_id
2456: and pev.input_value_id = piv.input_value_id
2457: AND piv.element_type_id = pet.element_type_id
2636: , p_flag_value VARCHAR2
2637: )
2638: IS
2639: SELECT ee.element_entry_id
2640: FROM pay_assignment_actions aa,
2641: pay_payroll_actions pa,
2642: pay_element_entries_f ee,
2643: pay_element_links_f el,
2644: pay_element_types_f et,
2701: SELECT count(*)
2702: FROM pay_run_results prr
2703: ,pay_run_result_values prrv1
2704: ,pay_run_result_values prrv2
2705: ,pay_assignment_actions paa
2706: ,pay_payroll_actions ppa
2707: where prr.run_result_id =prrv1.run_result_id
2708: and prrv1.input_value_id = p_exempted_id
2709: and prrv2.input_value_id = p_carry_over_id
4374:
4375: CURSOR c_max_asact(l_le_end_date DATE) IS
4376: SELECT MAX(paa.assignment_action_id)
4377: FROM pay_payroll_Actions ppa
4378: ,pay_assignment_actions paa
4379: WHERE paa.assignment_id =p_assignment_id
4380: AND paa.payroll_action_id = ppa.payroll_Action_id
4381: AND ppa.action_type in('R','Q')
4382: AND TRUNC(ppa.date_earned,'MM') = TRUNC(l_le_end_date,'MM')
4606: tax information elements in the current le in this tax year*/
4607:
4608: CURSOR c_recent_run_action IS
4609: SELECT to_number(substr(max(lpad(prev_asg.action_sequence,15,'0')||prev_asg.assignment_action_id),16))
4610: FROM pay_assignment_actions prev_asg,
4611: pay_payroll_actions prev_pay,
4612: per_time_periods ptp,
4613: pay_assignment_actions cur_asg,
4614: pay_payroll_actions cur_pay
4609: SELECT to_number(substr(max(lpad(prev_asg.action_sequence,15,'0')||prev_asg.assignment_action_id),16))
4610: FROM pay_assignment_actions prev_asg,
4611: pay_payroll_actions prev_pay,
4612: per_time_periods ptp,
4613: pay_assignment_actions cur_asg,
4614: pay_payroll_actions cur_pay
4615: WHERE prev_asg.assignment_id = p_assignment_id
4616: AND prev_asg.payroll_action_id = prev_pay.payroll_action_id
4617: AND prev_pay.action_type IN('R','Q')
4708: CURSOR csr_regular_run IS
4709: SELECT 'Y' FROM
4710: per_time_periods ptp,
4711: pay_payroll_actions pact,
4712: pay_assignment_actions assact,
4713: pay_payroll_actions bact,
4714: pay_assignment_actions bal_assact,
4715: pay_run_types_f prt
4716: WHERE bal_assact.assignment_action_id = p_assignment_action_id
4710: per_time_periods ptp,
4711: pay_payroll_actions pact,
4712: pay_assignment_actions assact,
4713: pay_payroll_actions bact,
4714: pay_assignment_actions bal_assact,
4715: pay_run_types_f prt
4716: WHERE bal_assact.assignment_action_id = p_assignment_action_id
4717: AND bal_assact.payroll_action_id = bact.payroll_action_id
4718: AND assact.payroll_action_id = pact.payroll_action_id