APPS.PAY_KR_NPA_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 128: ,pay_assignment_actions paa

124: AND bppa.effective_date between ass.effective_start_date and ass.effective_end_date
125: --
126: AND EXISTS ( SELECT NULL
127: FROM pay_payroll_actions ppa
128: ,pay_assignment_actions paa
129: WHERE ppa.payroll_action_id = paa.payroll_action_id
130: AND paa.assignment_id = ass.assignment_id
131: AND ppa.effective_date BETWEEN p_start_date
132: AND p_end_date

Line 138: ,pay_assignment_actions paa4

134: AND ppa.action_status = 'C'
135: )
136: AND NOT EXISTS( SELECT NULL
137: FROM pay_payroll_actions ppa4
138: ,pay_assignment_actions paa4
139: WHERE paa4.assignment_id = ass.assignment_id
140: AND paa4.source_action_id IS NULL
141: AND paa4.payroll_action_id = ppa4.payroll_action_id
142: AND ppa4.action_type = 'X'

Line 167: SELECT pay_assignment_actions_s.nextval

163: FETCH csr_date INTO l_start_date,l_end_date;
164: CLOSE csr_date;
165: FOR l_asg IN csr_asg(g_pact.bp_np_number,l_start_date,l_end_date) -- Bug 3506172
166: LOOP
167: SELECT pay_assignment_actions_s.nextval
168: INTO l_locking_action_id
169: FROM dual;
170: hr_nonrun_asact.insact(lockingactid => l_locking_action_id,
171: assignid => l_asg.assignment_id,

Line 193: p_context1 IN pay_assignment_actions.assignment_action_id%TYPE,

189: -- Archives item
190: --------------------------------------------------------------------------------+
191: PROCEDURE archive_item
192: ( p_item IN ff_user_entities.user_entity_name%TYPE,
193: p_context1 IN pay_assignment_actions.assignment_action_id%TYPE,
194: p_value IN OUT NOCOPY ff_archive_items.value%TYPE)
195: IS
196: CURSOR csr_get_user_entity_id(c_user_entity_name IN VARCHAR2)
197: IS

Line 273: pay_assignment_actions paa

269: SELECT paa.assignment_id,
270: pa.payroll_id,
271: pa.establishment_id -- Bug 3506172
272: FROM per_assignments_f pa,
273: pay_assignment_actions paa
274: WHERE paa.assignment_action_id = p_assignment_action_id
275: AND pa.assignment_id = paa.assignment_id
276: AND g_pact.effective_date BETWEEN pa.effective_start_date AND pa.effective_end_date;
277:

Line 285: FROM pay_assignment_actions paa

281: SELECT hoi.org_information1 business_place_code
282: ,pp.national_identifier registration_code
283: ,hoi.org_information2 branch_code
284: ,hoi1.org_information14 computerization_code
285: FROM pay_assignment_actions paa
286: ,per_assignments_f ass
287: ,per_people_f pp
288: ,hr_organization_information hoi
289: ,hr_organization_information hoi1