APPS.PAY_US_VERTEX_INTERFACE dependencies on PAY_PAYROLL_ACTIONS

Line 161: hr_utility.trace('1105 -> Fetching records from PAY_PAYROLL_ACTIONS ');

157: BEGIN
158: l_payroll_exist := 'N';
159: --{
160: hr_utility.trace('1100 -> Start payroll_run_exist ');
161: hr_utility.trace('1105 -> Fetching records from PAY_PAYROLL_ACTIONS ');
162: select 'Y'
163: into l_payroll_exist
164: from dual
165: where exists( select 1

Line 166: from PAY_PAYROLL_ACTIONS PPA

162: select 'Y'
163: into l_payroll_exist
164: from dual
165: where exists( select 1
166: from PAY_PAYROLL_ACTIONS PPA
167: where PPA.action_type IN ('R','Q')
168: and PPA.action_status = 'C'
169: and PPA.business_group_id = p_business_group_id);
170: /*

Line 173: from PAY_PAYROLL_ACTIONS PPA

169: and PPA.business_group_id = p_business_group_id);
170: /*
171: select 'Y'
172: into l_payroll_exist
173: from PAY_PAYROLL_ACTIONS PPA
174: where PPA.action_type IN ('R','Q')
175: and PPA.action_status = 'C'
176: and PPA.business_group_id = p_business_group_id;
177: */