DBA Data[Home] [Help]

APPS.PAY_NO_ARCHIVE_RSEA dependencies on PAY_ASSIGNMENT_ACTIONS

Line 340: ,pay_assignment_actions act

336: DISTINCT act.assignment_id assignment_id
337: FROM pay_payroll_actions ppa
338: ,pay_payroll_actions appa
339: ,pay_payroll_actions appa2
340: ,pay_assignment_actions act
341: ,pay_assignment_actions act1
342: ,pay_action_interlocks pai
343: ,per_all_assignments_f as1
344: ,hr_soft_coding_keyflex hsck

Line 341: ,pay_assignment_actions act1

337: FROM pay_payroll_actions ppa
338: ,pay_payroll_actions appa
339: ,pay_payroll_actions appa2
340: ,pay_assignment_actions act
341: ,pay_assignment_actions act1
342: ,pay_action_interlocks pai
343: ,per_all_assignments_f as1
344: ,hr_soft_coding_keyflex hsck
345: WHERE ppa.payroll_action_id = p_payroll_action_id

Line 400: ,pay_assignment_actions act

396: SELECT DISTINCT act.assignment_id assignment_id
397: FROM pay_payroll_actions ppa
398: ,pay_payroll_actions appa
399: ,pay_payroll_actions appa2
400: ,pay_assignment_actions act
401: ,pay_assignment_actions act1
402: ,pay_action_interlocks pai
403: ,per_all_assignments_f as1
404: ,hr_soft_coding_keyflex hsck

Line 401: ,pay_assignment_actions act1

397: FROM pay_payroll_actions ppa
398: ,pay_payroll_actions appa
399: ,pay_payroll_actions appa2
400: ,pay_assignment_actions act
401: ,pay_assignment_actions act1
402: ,pay_action_interlocks pai
403: ,per_all_assignments_f as1
404: ,hr_soft_coding_keyflex hsck
405: WHERE ppa.payroll_action_id = p_payroll_action_id