APPS.HR_ENTRY dependencies on PAY_COST_ALLOCATION_KEYFLEX

Line 5238: from pay_cost_allocation_keyflex pca

5234: return number is
5235: --
5236: cursor csr_cost_alloc_exists is
5237: select pca.cost_allocation_keyflex_id
5238: from pay_cost_allocation_keyflex pca
5239: where pca.cost_allocation_keyflex_id = p_cost_allocation_keyflex_id;
5240: --
5241: cursor get_seg_order is
5242: select substr(application_column_name,8,2)

Line 5336: from pay_cost_allocation_keyflex c

5332: segment(30) := p_segment30;
5333: --
5334: statem := '
5335: select cost_allocation_keyflex_id
5336: from pay_cost_allocation_keyflex c
5337: where c.id_flex_num = :p_cost_keyflex_structure
5338: and c.enabled_flag = ''Y''';
5339: --
5340: for i in 1..30 loop

Line 5435: select pay_cost_allocation_keyflex_s.nextval

5431: if g_debug then
5432: hr_utility.set_location('hr_entry.maintain_cost_keyflex', 8);
5433: end if;
5434: begin
5435: select pay_cost_allocation_keyflex_s.nextval
5436: into l_cost_allocation_keyflex_id
5437: from sys.dual;
5438: exception
5439: when NO_DATA_FOUND then

Line 5543: insert into pay_cost_allocation_keyflex

5539: if g_debug then
5540: hr_utility.set_location('hr_entry.maintain_cost_keyflex', 30);
5541: end if;
5542: begin
5543: insert into pay_cost_allocation_keyflex
5544: (cost_allocation_keyflex_id
5545: ,concatenated_segments
5546: ,id_flex_num
5547: ,last_update_date