APPS.PAY_CPT_BUS dependencies on PER_ASSIGNMENTS_F

Line 26: l_business_group_id per_assignments_f.business_group_id%TYPE;

22: --
23: l_proc varchar2(72) := g_package||'chk_assignment_id';
24: l_dummy varchar2(1);
25: l_api_updating boolean;
26: l_business_group_id per_assignments_f.business_group_id%TYPE;
27: --
28: cursor c1 is
29: select business_group_id
30: from per_assignments_f asg

Line 30: from per_assignments_f asg

26: l_business_group_id per_assignments_f.business_group_id%TYPE;
27: --
28: cursor c1 is
29: select business_group_id
30: from per_assignments_f asg
31: where asg.assignment_id = p_assignment_id
32: and p_effective_date between asg.effective_start_date
33: and asg.effective_end_date;
34: --

Line 89: -- raise error as assignment_id not found in per_assignments_f

85: if c1%notfound then
86: --
87: close c1;
88: --
89: -- raise error as assignment_id not found in per_assignments_f
90: -- table.
91: --
92: hr_utility.set_message(800, 'HR_74025_INVALID_ASSIGNMENT_ID');
93: hr_utility.raise_error;

Line 1345: per_assignments_f paf

1341: pay_action_contexts PA,
1342: ff_contexts C,
1343: pay_ca_emp_prov_tax_info_f PR,
1344: pay_assignment_actions paa,
1345: per_assignments_f paf
1346: where C.context_id = PA.context_id
1347: and C.context_name = 'JURISDICTION_CODE'
1348: and PA.context_value = PR.province_code
1349: and PA.assignment_id = PR.assignment_id