APPS.PER_PDP_BUS dependencies on PER_PERIODS_OF_PLACEMENT

Line 30: , per_periods_of_placement pdp

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , per_periods_of_placement pdp
31: where pdp.period_of_placement_id = p_period_of_placement_id
32: and pbg.business_group_id = pdp.business_group_id;
33: --
34: -- Declare local variables

Line 94: , per_periods_of_placement pdp

90: --
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups pbg
94: , per_periods_of_placement pdp
95: where pdp.period_of_placement_id = p_period_of_placement_id
96: and pbg.business_group_id = pdp.business_group_id;
97: --
98: -- Declare local variables

Line 164: from per_periods_of_placement pdp

160: ) return number is
161:
162: cursor c_get_period_of_placement_id is
163: select pdp.period_of_placement_id
164: from per_periods_of_placement pdp
165: where pdp.person_id = p_person_id
166: and pdp.date_start = p_date_start;
167:
168: l_proc varchar2(72) := g_package||'return_period_of_placement_id';

Line 1299: from per_periods_of_placement pdp

1295: l_proc varchar2(72) := g_package||'chk_person_id_date_start';
1296: --
1297: cursor csr_new_pers_date is
1298: select null
1299: from per_periods_of_placement pdp
1300: where pdp.person_id = p_person_id
1301: and pdp.date_start = p_date_start;
1302: --
1303: begin

Line 1332: -- on PER_PERIODS_OF_PLACEMENT

1328: if not l_api_updating
1329: then
1330: --
1331: -- Check that the Person ID and Date Start combination does not exist
1332: -- on PER_PERIODS_OF_PLACEMENT
1333: --
1334: hr_utility.set_location(l_proc, 6);
1335: --
1336: open csr_new_pers_date;

Line 1655: ,p_descflex_name => 'PER_PERIODS_OF_PLACEMENT'

1651: -- b) During insert.
1652: --
1653: hr_dflex_utility.ins_or_upd_descflex_attribs
1654: (p_appl_short_name => 'PER'
1655: ,p_descflex_name => 'PER_PERIODS_OF_PLACEMENT'
1656: ,p_attribute_category => p_rec.attribute_category
1657: ,p_attribute1_name => 'ATTRIBUTE1'
1658: ,p_attribute1_value => p_rec.attribute1
1659: ,p_attribute2_name => 'ATTRIBUTE2'