APPS.PAY_IN_EOY_ER_RETURNS dependencies on PAY_ACTION_INFORMATION

Line 84: FROM pay_action_information

80:
81: CURSOR c_count
82: IS
83: SELECT COUNT(*)
84: FROM pay_action_information
85: WHERE action_information_category = 'IN_EOY_PERSON'
86: AND action_context_type = 'AAP'
87: AND action_information2 = p_assess_year
88: AND action_information3 = p_gre_org_id

Line 90: FROM pay_action_information pai

86: AND action_context_type = 'AAP'
87: AND action_information2 = p_assess_year
88: AND action_information3 = p_gre_org_id
89: AND action_context_id IN ( SELECT MAX(pai.action_context_id)
90: FROM pay_action_information pai
91: ,pay_assignment_actions paa
92: ,per_assignments_f asg
93: WHERE pai.action_information_category = 'IN_EOY_PERSON'
94: AND pai.action_context_type = 'AAP'

Line 157: FROM pay_action_information

153:
154: CURSOR c_count
155: IS
156: SELECT COUNT(*)
157: FROM pay_action_information
158: WHERE action_information_category = 'IN_EOY_PERSON'
159: AND action_context_type = 'AAP'
160: AND action_information2 = p_assess_year
161: AND action_information3 = p_gre_org_id

Line 163: FROM pay_action_information pai

159: AND action_context_type = 'AAP'
160: AND action_information2 = p_assess_year
161: AND action_information3 = p_gre_org_id
162: AND action_context_id IN ( SELECT MAX(pai.action_context_id)
163: FROM pay_action_information pai
164: ,pay_assignment_actions paa
165: ,per_assignments_f asg
166: WHERE pai.action_information_category = 'IN_EOY_PERSON'
167: AND pai.action_context_type = 'AAP'

Line 304: FROM pay_action_information

300:
301: CURSOR csr_tax_details(p_balance VARCHAR2,p_action_context_id NUMBER,p_source_id IN NUMBER)
302: IS
303: SELECT NVL(SUM(action_information2),0)
304: FROM pay_action_information
305: WHERE action_information_category = 'IN_EOY_ASG_SAL'
306: AND action_context_type = 'AAP'
307: AND action_information1 = p_balance
308: AND action_context_id = p_action_context_id

Line 314: FROM pay_action_information pai

310:
311: CURSOR csr_get_max_cont_id IS
312: SELECT MAX(pai.action_context_id) action_cont_id
313: ,source_id sour_id
314: FROM pay_action_information pai
315: ,pay_assignment_actions paa
316: ,per_assignments_f asg
317: WHERE pai.action_information_category = 'IN_EOY_PERSON'
318: AND pai.assignment_id = asg.assignment_id

Line 391: FROM pay_action_information

387: SELECT NVL(action_information2,'0')
388: ,NVL(action_information3,'0')
389: ,NVL(action_information4,'0')
390: ,NVL(action_information5,'0')
391: FROM pay_action_information
392: WHERE action_information_category = p_category
393: AND action_information1 = p_component_name
394: AND action_context_id = p_context_id
395: AND source_id = p_source_id;