eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PSP_BUS dependencies on PER_PARENT_SPINES

Line 237: -- Validates that a parent_spine_id exists in table per_parent_spines.

233: -- |-----------------< chk_parent_spine_id >--------------------------------|
234: -- ---------------------------------------------------------------------------
235: --
236: -- Description:
237: -- Validates that a parent_spine_id exists in table per_parent_spines.
238: --
239: -- Pre-conditions:
240: -- parent_spine_id must be valid.
241: -- business_group_id must be valid.

Line 254: -- If a row does not exist in per_parent_spines for

250: -- Post Success:
251: -- If a row does exist; processing continues.
252: --
253: -- Post Failure:
254: -- If a row does not exist in per_parent_spines for
255: -- a given reason id then an error will be raised and processing terminated.
256: --
257: -- Access Status:
258: -- Internal Table Handler Use Only.

Line 279: from per_parent_spines pps

275: l_business_group_id number;
276: --
277: cursor csr_valid_parent_spines is
278: select null
279: from per_parent_spines pps
280: where pps.business_group_id = p_business_group_id
281: and pps.parent_spine_id = p_parent_spine_id;
282: --
283: begin