APPS.PAY_STA_BUS dependencies on PER_ASSIGNMENTS_F

Line 95: -- - the assignment_id exists in PER_ASSIGNMENTS_F

91: -- ----------------------------------------------------------------------------
92: --
93: -- Description
94: -- This procedure validates the assignment_id with the following checks:
95: -- - the assignment_id exists in PER_ASSIGNMENTS_F
96: -- - the assignment's business group must match the business group of this
97: -- tax record.
98: -- The tax record's business_group_id is also validated by checking that it
99: -- matches an existing business_group_id in PER_ASSIGNMENTS_F.

Line 99: -- matches an existing business_group_id in PER_ASSIGNMENTS_F.

95: -- - the assignment_id exists in PER_ASSIGNMENTS_F
96: -- - the assignment's business group must match the business group of this
97: -- tax record.
98: -- The tax record's business_group_id is also validated by checking that it
99: -- matches an existing business_group_id in PER_ASSIGNMENTS_F.
100: --
101: -- Pre-Conditions
102: -- None.
103: --

Line 133: l_business_group_id per_assignments_f.business_group_id%TYPE;

129: --
130: l_proc varchar2(72) := g_package||'chk_assignment_id';
131: l_dummy varchar2(1);
132: l_api_updating boolean;
133: l_business_group_id per_assignments_f.business_group_id%TYPE;
134: --
135: cursor c1 is
136: select business_group_id
137: from per_assignments_f asg

Line 137: from per_assignments_f asg

133: l_business_group_id per_assignments_f.business_group_id%TYPE;
134: --
135: cursor c1 is
136: select business_group_id
137: from per_assignments_f asg
138: where asg.assignment_id = p_assignment_id
139: and p_effective_date between asg.effective_start_date
140: and asg.effective_end_date;
141: --

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

184: if c1%notfound then
185: --
186: close c1;
187: --
188: -- raise error as assignment_id not found in per_assignments_f
189: -- table.
190: --
191: hr_utility.set_message(801, 'HR_51746_ASG_INV_ASG_ID');
192: hr_utility.raise_error;

Line 1291: from per_assignments_f asg,

1287: );
1288: --
1289: cursor csr_check_work_loc(p_csr_tmp_date in date) is
1290: select null
1291: from per_assignments_f asg,
1292: hr_locations hrl
1293: where asg.assignment_id = pay_sta_shd.g_old_rec.assignment_id
1294: and hrl.location_id = asg.location_id
1295: and asg.effective_end_date > p_csr_tmp_date

Line 1303: from per_assignments_f asg,

1299: and pus.state_code = pay_sta_shd.g_old_rec.state_code);
1300: --
1301: cursor csr_check_residence_loc(p_csr_tmp_date in date) is
1302: select null
1303: from per_assignments_f asg,
1304: per_addresses pad
1305: where asg.assignment_id = pay_sta_shd.g_old_rec.assignment_id
1306: and pad.person_id = asg.person_id
1307: and pad.primary_flag = 'Y'