DBA Data[Home] [Help]

APPS.PER_SG_ASG_LEG_HOOK dependencies on PAY_ASSIGNMENT_ACTIONS

Line 38: ,pay_assignment_actions paa

34: ,c_bg_id per_business_groups.business_group_id%TYPE
35: ,c_effective_date DATE) IS
36: SELECT 'YES'
37: FROM pay_payroll_actions ppa
38: ,pay_assignment_actions paa
39: WHERE paa.assignment_id = c_assignment_id
40: and ppa.payroll_action_id = paa.payroll_action_id
41: and ppa.business_group_id = c_bg_id
42: and ppa.action_type in ('I','B','V','R','Q')

Line 57: ,pay_assignment_actions paa

53: ,c_bg_id per_business_groups.business_group_id%TYPE
54: ,c_effective_date DATE) IS
55: SELECT 'YES'
56: FROM pay_payroll_actions ppa
57: ,pay_assignment_actions paa
58: WHERE paa.assignment_id = c_assignment_id
59: AND ppa.business_group_id = c_bg_id
60: AND ppa.payroll_action_id = paa.payroll_action_id
61: AND ppa.action_type in ('I','B','V','R','Q')