DBA Data[Home] [Help]

APPS.HR_ORGANIZATION_UNITS_PKG dependencies on PER_COLLECTIVE_AGREEMENTS_V

Line 866: from per_collective_agreements_v

862: PROCEDURE Validate_delete (X_Organization_Id NUMBER,
863: X_Business_Group_Id Number) IS
864: cursor csr_employer is
865: select '1'
866: from per_collective_agreements_v
867: where employer_organization_id = X_Organization_Id;
868:
869: cursor csr_barg_units is
870: select '1'

Line 871: from per_collective_agreements_v

867: where employer_organization_id = X_Organization_Id;
868:
869: cursor csr_barg_units is
870: select '1'
871: from per_collective_agreements_v
872: where bargaining_organization_id = X_Organization_Id;
873:
874: cursor csr_leg_code is
875: select legislation_code