10:
11: -- global PL/SQL records and tables
12:
13: TYPE r_ret_criteria is RECORD (
14: location_id per_all_assignments_f.location_id%TYPE,
15: payroll_id per_all_assignments_f.payroll_id%TYPE,
16: organization_id per_all_assignments_f.organization_id%TYPE,
17: gre_id hr_soft_coding_keyflex.segment1%TYPE
18: );
11: -- global PL/SQL records and tables
12:
13: TYPE r_ret_criteria is RECORD (
14: location_id per_all_assignments_f.location_id%TYPE,
15: payroll_id per_all_assignments_f.payroll_id%TYPE,
16: organization_id per_all_assignments_f.organization_id%TYPE,
17: gre_id hr_soft_coding_keyflex.segment1%TYPE
18: );
19:
12:
13: TYPE r_ret_criteria is RECORD (
14: location_id per_all_assignments_f.location_id%TYPE,
15: payroll_id per_all_assignments_f.payroll_id%TYPE,
16: organization_id per_all_assignments_f.organization_id%TYPE,
17: gre_id hr_soft_coding_keyflex.segment1%TYPE
18: );
19:
20: g_ret_criteria hxc_generic_retrieval_pkg.r_ret_criteria;