DBA Data[Home] [Help]

APPS.PAY_FR_GENERAL dependencies on PAY_RUN_RESULTS

Line 83: , pay_run_results prr

79: cursor pay_asg_act_csr is
80: select paa.assignment_action_id, ppa.effective_date
81: from pay_payroll_actions ppa
82: , pay_assignment_actions paa
83: , pay_run_results prr
84: where ppa.business_group_id = p_business_group_id
85: and ppa.action_type in ('Q','R')
86: and ppa.action_status in ('C','I')
87: and ppa.effective_date between trunc(p_date_earned,'MONTH')

Line 141: from pay_run_results prr

137:
138:
139: cursor pay_run_result_csr is
140: select prrv.result_value
141: from pay_run_results prr
142: , pay_element_types_f pet
143: , pay_input_values_f piv
144: , pay_run_result_values prrv
145: where prr.assignment_action_id = g_prior_asg_action_id