DBA Data[Home] [Help]

APPS.PER_SG_ASG_LEG_HOOK dependencies on PAY_PAYROLL_ACTIONS

Line 37: FROM pay_payroll_actions ppa

33: (c_assignment_id per_all_assignments_f.assignment_id%TYPE
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

Line 56: FROM pay_payroll_actions ppa

52: (c_assignment_id per_all_assignments_f.assignment_id%TYPE
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