APPS.PAY_AU_PAYMENT_SUMMARY dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 757: l_fw_asg_f_status_id per_assignment_status_types.assignment_status_type_id%TYPE;

753:
754: cnt number := 1;
755: idx number := 1;
756: l_registered_employer hr_organization_units.organization_id%type;
757: l_fw_asg_f_status_id per_assignment_status_types.assignment_status_type_id%TYPE;
758: l_fw_asg_j_status_id per_assignment_status_types.assignment_status_type_id%TYPE;
759: l_fw_exist varchar2(1);
760: raise_no_status_type exception;
761: raise_invalid_LE_fw_setup exception;

Line 758: l_fw_asg_j_status_id per_assignment_status_types.assignment_status_type_id%TYPE;

754: cnt number := 1;
755: idx number := 1;
756: l_registered_employer hr_organization_units.organization_id%type;
757: l_fw_asg_f_status_id per_assignment_status_types.assignment_status_type_id%TYPE;
758: l_fw_asg_j_status_id per_assignment_status_types.assignment_status_type_id%TYPE;
759: l_fw_exist varchar2(1);
760: raise_no_status_type exception;
761: raise_invalid_LE_fw_setup exception;
762:

Line 9689: ,per_assignment_status_types past

9685: cursor csr_get_fw_status_exist (c_date date) is
9686: select 'Y'
9687: from per_all_assignments_f paa
9688: ,per_time_periods ptp
9689: ,per_assignment_status_types past
9690: where paa.assignment_id = p_assignment_id
9691: and paa.payroll_id = ptp.payroll_id
9692: and c_date = ptp.end_date
9693: and past.assignment_status_type_id = paa.assignment_status_type_id