DBA Data[Home] [Help]

APPS.HR_PERSON_RECORD dependencies on PAY_EMPLOYEE_ACTION_INFO_V

Line 2111: from pay_employee_action_info_v peai

2107: from pay_ac_emp_sum_action_info_v
2108: where action_context_id = p_asg_action_id
2109: and action_information_category = 'AC SUMMARY YTD') NET_PAY_YTD
2110:
2111: from pay_employee_action_info_v peai
2112: where action_context_id = p_asg_action_id
2113: and assignment_id = p_asg_id
2114: and trunc(effective_date) <= p_eff_date
2115: and location_name = p_loc_name;

Line 2140: from pay_employee_action_info_v empv,

2136: pbg.currency_code ,
2137: to_char(beginning_date,'YYYY-MM-DD') ,
2138: to_char(ending_date,'YYYY-MM-DD'),
2139: paa.assignment_id
2140: from pay_employee_action_info_v empv,
2141: pay_assignment_actions paa,
2142: per_business_groups pbg
2143: where empv.action_context_id = p_asg_action_id
2144: and empv.action_context_id = paa.assignment_action_id