APPS.PER_SG_ASG_LEG_HOOK dependencies on PER_BUSINESS_GROUPS

Line 23: l_bg_id per_business_groups.business_group_id%TYPE;

19: AND hsc.soft_coding_keyflex_id = a.soft_coding_keyflex_id
20: AND c_effective_date BETWEEN a.effective_start_date AND a.effective_end_date;
21:
22: g_debug BOOLEAN;
23: l_bg_id per_business_groups.business_group_id%TYPE;
24: l_future_actions_exist VARCHAR2(10);
25: l_actions_exist VARCHAR2(10);
26: l_tax_unit_id hr_soft_coding_keyflex.segment1%TYPE;
27:

Line 34: ,c_bg_id per_business_groups.business_group_id%TYPE

30: actions in the period or in future periods */
31:
32: CURSOR c_check_future_actions
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

Line 53: ,c_bg_id per_business_groups.business_group_id%TYPE

49: of the employee assignment */
50:
51: CURSOR c_check_actions
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