APPS.HR_ENTRY dependencies on PAY_COST_ALLOCATION_KEYFLEX

Line 5627: from pay_cost_allocation_keyflex pca

5623: return number is
5624: --
5625: cursor csr_cost_alloc_exists is
5626: select pca.cost_allocation_keyflex_id
5627: from pay_cost_allocation_keyflex pca
5628: where pca.cost_allocation_keyflex_id = p_cost_allocation_keyflex_id;
5629: --
5630: cursor get_seg_order is
5631: select substr(application_column_name,8,2)

Line 5725: from pay_cost_allocation_keyflex c

5721: segment(30) := p_segment30;
5722: --
5723: statem := '
5724: select cost_allocation_keyflex_id
5725: from pay_cost_allocation_keyflex c
5726: where c.id_flex_num = :p_cost_keyflex_structure
5727: and c.enabled_flag = ''Y''';
5728: --
5729: for i in 1..30 loop

Line 5824: select pay_cost_allocation_keyflex_s.nextval

5820: if g_debug then
5821: hr_utility.set_location('hr_entry.maintain_cost_keyflex', 8);
5822: end if;
5823: begin
5824: select pay_cost_allocation_keyflex_s.nextval
5825: into l_cost_allocation_keyflex_id
5826: from sys.dual;
5827: exception
5828: when NO_DATA_FOUND then

Line 5932: insert into pay_cost_allocation_keyflex

5928: if g_debug then
5929: hr_utility.set_location('hr_entry.maintain_cost_keyflex', 30);
5930: end if;
5931: begin
5932: insert into pay_cost_allocation_keyflex
5933: (cost_allocation_keyflex_id
5934: ,concatenated_segments
5935: ,id_flex_num
5936: ,last_update_date