APPS.PAY_US_EMPLOYEE_BALANCES dependencies on PAY_ASSIGNMENT_ACTIONS

Line 126: from pay_assignment_actions pac

122:
123: CURSOR c_action_type
124: IS
125: select pay.action_type
126: from pay_assignment_actions pac
127: ,pay_payroll_actions pay
128: where pay.payroll_action_id = pac.payroll_action_id
129: and pac.assignment_id = p_assignment_id
130: and pac.action_status = 'C'

Line 250: , pay_assignment_actions paa

246: , pay_defined_balances pdb
247: , pay_bal_attribute_definitions pbad
248: , pay_balance_attributes pba
249: , pay_balance_types pbt
250: , pay_assignment_actions paa
251: , pay_payroll_actions ppa
252: WHERE pbad.attribute_name = l_attribute_name
253: AND pbad.business_group_id is null
254: AND pbad.legislation_code = 'US'

Line 336: , pay_assignment_actions paa

332: , pay_defined_balances pdb
333: , pay_bal_attribute_definitions pbad
334: , pay_balance_attributes pba
335: , pay_balance_types pbt
336: , pay_assignment_actions paa
337: , pay_payroll_actions ppa
338: WHERE pbad.attribute_name = l_attribute_name
339: AND pbad.business_group_id is null
340: AND pbad.legislation_code = 'US'

Line 418: , pay_assignment_actions paa

414: p_business_group_id ,--ctlglobals.bg_id
415: NULL) YTD_VAL
416: from pay_element_types_f pet
417: , pay_payroll_actions ppa
418: , pay_assignment_actions paa
419: , pay_balance_types pbt
420: WHERE pet.classification_id = p_classification_id
421: AND pet.element_information10 is not null
422: AND PAA.ASSIGNMENT_ACTION_ID =p_assignment_action_id

Line 431: pay_assignment_actions asg,

427: AND paa.assignment_id = p_assignment_id
428: AND pet.element_information10 =pbt.balance_type_id
429: AND EXISTS (SELECT 'x'
430: FROM pay_payroll_actions pact,
431: pay_assignment_actions asg,
432: pay_run_results rr
433: where rr.element_type_id + 0 = pet.element_type_id
434: and rr.assignment_action_id = asg.assignment_action_id
435: and asg.assignment_id = paa.assignment_id