eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IN_TAX_UTILS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 198: (p_assact in pay_assignment_actions.assignment_Action_id%type,

194: -- IN : --
195: -- --
196: --------------------------------------------------------------------------
197: FUNCTION get_house_rent_info_entry_id
198: (p_assact in pay_assignment_actions.assignment_Action_id%type,
199: p_effective_date in date,
200: p_year_start in date,
201: p_year_end in date,
202: p_entry_id_type_flag out nocopy varchar2 ,

Line 223: ,pay_assignment_actions pac

219: from pay_element_types_f pet
220: ,pay_input_values_f piv
221: ,pay_element_entries_f pee
222: ,pay_element_entry_values_f pev
223: ,pay_assignment_actions pac
224: where pet.element_name ='House Rent Information'
225: and piv.name = 'JAN'
226: and pet.legislation_code ='IN'
227: and pet.element_type_id = piv.element_type_id

Line 243: ,pay_assignment_actions pac

239: from pay_element_types_f pet
240: ,pay_input_values_f piv
241: ,pay_element_entries_f pee
242: ,pay_element_entry_values_f pev
243: ,pay_assignment_actions pac
244: where pet.element_name ='House Rent Information'
245: and piv.name = 'JAN'
246: and pet.legislation_code ='IN'
247: and pet.element_type_id = piv.element_type_id

Line 500: pay_assignment_Actions paa,

496: /*Bug:3907894 Added ppa.effective_date in the select statement and fetched it in the table l_eff_date_tbl */
497: select paa.assignment_action_id,pay_in_tax_utils.get_period_number(ppa.payroll_id,ppa.date_earned),ppa.date_earned
498: bulk collect into l_assact_tbl,l_month_number_tbl,l_eff_date_tbl
499: from pay_payroll_Actions ppa,
500: pay_assignment_Actions paa,
501: per_assignments_f asg -- Added to remove NMV as per bug 4774108
502: where ppa.payroll_Action_id = paa.payroll_Action_id
503: and paa.assignment_id = p_assignment_id
504: and paa.assignment_id = asg.assignment_id-- Added to remove NMV as per bug 4774108

Line 511: from pay_assignment_actions pac

507: -- and paa.source_action_id is not null -- Commented for bug 4774514
508: and ppa.date_earned between p_year_start and p_year_end
509: and ppa.date_earned between asg.effective_start_date and asg.effective_end_date
510: and paa.action_sequence = ( select max(pac.action_sequence)
511: from pay_assignment_actions pac
512: ,pay_payroll_actions ppa1
513: where pac.assignment_id = paa.assignment_id
514: and pac.payroll_action_id = ppa1.payroll_action_id
515: and ppa1.date_earned between p_year_start and p_year_end

Line 894: FROM pay_assignment_actions

890: --
891:
892: SELECT assignment_id
893: INTO l_assignment_id
894: FROM pay_assignment_actions
895: WHERE assignment_action_id = p_assact_id ;
896:
897: SELECT nvl(pps.actual_termination_date,paa.effective_end_Date),payroll_id
898: INTO l_asg_end_date,l_payroll_id

Line 2205: FROM pay_assignment_actions aa,

2201: , p_flag_value VARCHAR2
2202: )
2203: IS
2204: SELECT ee.element_entry_id
2205: FROM pay_assignment_actions aa,
2206: pay_payroll_actions pa,
2207: pay_element_entries_f ee,
2208: pay_element_links_f el,
2209: pay_element_types_f et,

Line 2269: ,pay_assignment_actions paa

2265: SELECT count(*)
2266: FROM pay_run_results prr
2267: ,pay_run_result_values prrv1
2268: ,pay_run_result_values prrv2
2269: ,pay_assignment_actions paa
2270: ,pay_payroll_actions ppa
2271: where prr.run_result_id =prrv1.run_result_id
2272: and prrv1.input_value_id = p_exempted_id
2273: and prrv2.input_value_id = p_carry_over_id

Line 3325: ,pay_assignment_actions paa

3321:
3322: CURSOR c_max_asact(l_le_end_date DATE) IS
3323: SELECT MAX(paa.assignment_action_id)
3324: FROM pay_payroll_Actions ppa
3325: ,pay_assignment_actions paa
3326: WHERE paa.assignment_id =p_assignment_id
3327: AND paa.payroll_action_id = ppa.payroll_Action_id
3328: AND ppa.action_type in('R','Q')
3329: AND TRUNC(ppa.date_earned,'MM') = TRUNC(l_le_end_date,'MM')

Line 3557: FROM pay_assignment_actions prev_asg,

3553: tax information elements in the current le in this tax year*/
3554:
3555: CURSOR c_recent_run_action IS
3556: SELECT to_number(substr(max(lpad(prev_asg.action_sequence,15,'0')||prev_asg.assignment_action_id),16))
3557: FROM pay_assignment_actions prev_asg,
3558: pay_payroll_actions prev_pay,
3559: per_time_periods ptp,
3560: pay_assignment_actions cur_asg,
3561: pay_payroll_actions cur_pay

Line 3560: pay_assignment_actions cur_asg,

3556: SELECT to_number(substr(max(lpad(prev_asg.action_sequence,15,'0')||prev_asg.assignment_action_id),16))
3557: FROM pay_assignment_actions prev_asg,
3558: pay_payroll_actions prev_pay,
3559: per_time_periods ptp,
3560: pay_assignment_actions cur_asg,
3561: pay_payroll_actions cur_pay
3562: WHERE prev_asg.assignment_id = p_assignment_id
3563: AND prev_asg.payroll_action_id = prev_pay.payroll_action_id
3564: AND prev_pay.action_type IN('R','Q')

Line 3659: pay_assignment_actions assact,

3655: CURSOR csr_regular_run IS
3656: SELECT 'Y' FROM
3657: per_time_periods ptp,
3658: pay_payroll_actions pact,
3659: pay_assignment_actions assact,
3660: pay_payroll_actions bact,
3661: pay_assignment_actions bal_assact,
3662: pay_run_types_f prt
3663: WHERE bal_assact.assignment_action_id = p_assignment_action_id

Line 3661: pay_assignment_actions bal_assact,

3657: per_time_periods ptp,
3658: pay_payroll_actions pact,
3659: pay_assignment_actions assact,
3660: pay_payroll_actions bact,
3661: pay_assignment_actions bal_assact,
3662: pay_run_types_f prt
3663: WHERE bal_assact.assignment_action_id = p_assignment_action_id
3664: AND bal_assact.payroll_action_id = bact.payroll_action_id
3665: AND assact.payroll_action_id = pact.payroll_action_id