APPS.PER_GRS_BUS dependencies on PER_COLLECTIVE_AGREEMENTS

Line 86: -- Validates that values enterd for this column exist in the PER_COLLECTIVE_AGREEMENTS

82: -- Desciption :
83: --
84: -- Validates that COLLECTIVE_AGREEMENT_ID is not null
85: --
86: -- Validates that values enterd for this column exist in the PER_COLLECTIVE_AGREEMENTS
87: -- table.
88: --
89: -- Pre-conditions:
90: --

Line 119: from per_collective_agreements per

115: -- Cursor to check that COLLECTIVE_AGREEMENT_ID exists
116: --
117: cursor csr_valid_cagr_id is
118: select '1'
119: from per_collective_agreements per
120: where per.collective_agreement_id = p_collective_agreement_id;
121: --
122: begin
123: hr_utility.set_location('Entering:'||l_proc,5);