APPS.PAY_STATE_TAX_RULE_API dependencies on PER_ASSIGNMENTS_F

Line 255: from per_assignments_f asg

251: and sta.state_code = p_state_code;
252: --
253: cursor csr_bus_grp is
254: select asg.business_group_id
255: from per_assignments_f asg
256: where asg.assignment_id = p_assignment_id
257: and l_effective_date between asg.effective_start_date
258: and asg.effective_end_date;
259: --

Line 297: PER_ASSIGNMENTS_F paf,

293: cursor csr_fed_or_def is
294: select hoi.org_information12
295: from PAY_US_STATES pus,
296: HR_ORGANIZATION_INFORMATION hoi,
297: PER_ASSIGNMENTS_F paf,
298: HR_SOFT_CODING_KEYFLEX hsck
299: where paf.assignment_id = p_assignment_id
300: and paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
301: and hoi.organization_id = hsck.segment1

Line 328: -- The assignment does not exist in PER_ASSIGNMENTS_F

324: fetch csr_bus_grp into l_business_group_id;
325: if csr_bus_grp%NOTFOUND then
326: close csr_bus_grp;
327: --
328: -- The assignment does not exist in PER_ASSIGNMENTS_F
329: --
330: hr_utility.set_message(801, 'HR_51253_PYP_ASS__NOT_VALID');
331: hr_utility.raise_error;
332: end if;