APPS.PAY_SE_TRNR dependencies on PAY_ASSIGNMENT_ACTIONS

Line 47: FROM pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai

43: p_legal_employer_id pay_action_information.action_information13%TYPE --,
44: -- p_sort_order pay_action_information.action_information20%TYPE
45: ) IS
46: SELECT DISTINCT action_information14 division_code, action_information16 division
47: FROM pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai
48: WHERE paa.payroll_action_id = p_payroll_action_id
49: AND assg.payroll_action_id = paa.payroll_action_id
50: AND pai.action_context_id = assg.assignment_action_id
51: AND action_context_type = 'AAP'

Line 64: FROM pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai

60: p_legal_employer_id pay_action_information.action_information13%TYPE,
61: p_div pay_action_information.action_information14%TYPE
62: ) IS
63: SELECT DISTINCT action_information15 area_code, action_information17 agreement_area
64: FROM pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai
65: WHERE paa.payroll_action_id = p_payroll_action_id
66: AND assg.payroll_action_id = paa.payroll_action_id
67: AND pai.action_context_id = assg.assignment_action_id
68: AND action_context_type = 'AAP'

Line 211: FROM pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai

207: precedence_date,
208: fnd_date.canonical_to_date (action_information10) termination_date, action_information11 emp_type,
209: action_information12
210: emp_sec
211: FROM pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai
212: WHERE paa.payroll_action_id = '
213: || l_payroll_action_id
214: || ' AND assg.payroll_action_id = paa.payroll_action_id
215: AND pai.action_context_id = assg.assignment_action_id