APPS.PAY_US_RETRO_OVERLAP dependencies on PAY_PAYROLL_ACTIONS

Line 80: FROM pay_payroll_actions ppa

76: /*
77: CURSOR c_check_retro_pay_element (p_legislation_code IN varchar2)
78: IS
79: SELECT 'Y'
80: FROM pay_payroll_actions ppa
81: WHERE ppa.action_type = 'L'
82: AND EXISTS ( SELECT 'Y'
83: FROM hr_organization_information hoi,
84: hr_all_organization_units hou

Line 93: FROM pay_payroll_actions ppa

89: )
90: AND ROWNUM < 2; */
91: /* Above query is introduced to improve performance
92: SELECT 'Y'
93: FROM pay_payroll_actions ppa
94: WHERE ppa.action_type = 'L'
95: AND EXISTS ( SELECT 'Y'
96: FROM hr_organization_information hoi
97: WHERE hoi.org_information_context = 'Business Group Information'

Line 115: pay_payroll_actions ppa

111: IS
112: SELECT 'Y'
113: FROM pay_assignment_actions paa ,
114: pay_retro_assignments pra,
115: pay_payroll_actions ppa
116: WHERE ppa.action_type = 'L'
117: AND ppa.business_group_id = p_business_group_id
118: AND paa.payroll_action_id = ppa.payroll_action_id
119: AND pra.retro_assignment_action_id=paa.assignment_action_id

Line 271: FROM pay_payroll_actions

267: IF (c_chk_adv_retro_pay_enabled%NOTFOUND) THEN
268: l_retro_payroll_count := -1;
269: SELECT count(1)
270: INTO l_retro_payroll_count
271: FROM pay_payroll_actions
272: WHERE business_group_id = lc.business_group_id
273: AND action_type = 'L';
274: IF l_retro_payroll_count = 0 THEN
275: l_adv_ret_bg_count := l_adv_ret_bg_count + 1;