APPS.PAY_CORE_UPGRADE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 103: from per_all_assignments_f

99: --
100: cursor c_get_asgs (p_person_id in number)
101: is
102: select distinct assignment_id
103: from per_all_assignments_f
104: where person_id = p_person_id;
105: --
106: begin
107: --

Line 1141: from per_all_assignments_f asg,

1137: if (g_leg_code_cached = FALSE) then
1138: --
1139: select pbg.legislation_code, pbg.business_group_id
1140: into l_leg_code, l_bus_grp
1141: from per_all_assignments_f asg,
1142: per_business_groups_perf pbg
1143: where asg.assignment_id = p_assignment_id
1144: and pbg.business_group_id = asg.business_group_id
1145: and rownum = 1;

Line 1428: per_all_assignments_f paf

1424: pbg.legislation_code
1425: into l_bus_grpid,
1426: l_leg_code
1427: from per_business_groups_perf pbg,
1428: per_all_assignments_f paf
1429: where paf.assignment_id = p_asg_id
1430: and paf.business_group_id = pbg.business_group_id;
1431: --
1432: -- We can not do the upgrade unless

Line 1597: from per_all_assignments_f asg

1593: select ''
1594: into l_dummy
1595: from dual
1596: where exists (select ''
1597: from per_all_assignments_f asg
1598: where asg.assignment_id = p_object_id
1599: and asg.people_group_id is not null
1600: and asg.assignment_type in ('A','O'));
1601: l_qualifier := 'Y';

Line 1627: from per_all_assignments_f asg

1623: cursor csr_asg (p_asg_id number) is
1624: select asg.assignment_type,
1625: asg.effective_start_date,
1626: asg.effective_end_date
1627: from per_all_assignments_f asg
1628: where asg.assignment_id = p_asg_id
1629: order by asg.effective_start_date;
1630: --
1631: cursor csr_alu (p_asg_id number,

Line 1661: from per_all_assignments_f asg

1657: --
1658: delete pay_assignment_link_usages_f alu
1659: where not exists (
1660: select null
1661: from per_all_assignments_f asg
1662: where asg.assignment_id = alu.assignment_id
1663: and asg.assignment_type not in ('A','O')
1664: )
1665: and alu.assignment_id = p_assignment_id;

Line 1803: from per_all_assignments_f asg

1799: select ''
1800: into l_dummy
1801: from dual
1802: where exists (select ''
1803: from per_all_assignments_f asg
1804: where asg.assignment_id = p_object_id
1805: and asg.assignment_type = 'E'
1806: and asg.people_group_id is not null);
1807: l_qualifier := 'Y';