DBA Data[Home] [Help]

APPS.PQP_TIAALOD_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 370: i per_all_assignments_f.assignment_id%TYPE;

366: v_end_date per_assignments_f.effective_end_date%TYPE;
367: l_update_flag BOOLEAN;
368: l_insert_valid BOOLEAN;
369: l_proc_name VARCHAR2(150) := g_proc_name ||'load_balances';
370: i per_all_assignments_f.assignment_id%TYPE;
371:
372: BEGIN
373: hr_utility.set_location('Entering : '||l_proc_name, 10);
374: IF l_org_ppg IS NULL AND

Line 814: l_prev_assignment_id per_all_assignments_f.assignment_id%TYPE := NULL;

810: AND hox.organization_id = paf.organization_id
811: AND hou.organization_id = paa.tax_unit_id
812: ORDER BY paa.assignment_id,ppa.payroll_id, paa.assignment_action_id;
813:
814: l_prev_assignment_id per_all_assignments_f.assignment_id%TYPE := NULL;
815: l_prev_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
816: l_prev_end_date date;
817: l_count NUMBER(5);
818: l_proc_name VARCHAR2(150) := g_proc_name ||'load_data';