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 1302: from per_periods_of_placement pdp

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

Line 1335: -- on PER_PERIODS_OF_PLACEMENT

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

Line 1658: ,p_descflex_name => 'PER_PERIODS_OF_PLACEMENT'

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