25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , pay_cost_allocations_f cal
30: where cal.cost_allocation_id = p_cost_allocation_id
31: and pbg.business_group_id = cal.business_group_id;
32: --
33: -- Declare local variables
85: --
86: cursor csr_leg_code is
87: select pbg.legislation_code
88: from per_business_groups pbg
89: , pay_cost_allocations_f cal
90: where cal.cost_allocation_id = p_cost_allocation_id
91: and pbg.business_group_id = cal.business_group_id;
92: --
93: -- Declare local variables
406: -- Cursor to check that a retro component exists.
407: --
408: cursor csr_duplicate_cost_keyflex is
409: select null
410: from pay_cost_allocations_f
411: where assignment_id = p_assignment_id
412: and cost_allocation_id <> nvl(p_cost_allocation_id, hr_api.g_number)
413: and cost_allocation_keyflex_id = p_cost_allocation_keyflex_id
414: and effective_start_date <= p_validation_end_date