DBA Data[Home] [Help]

APPS.PER_PYP_BUS dependencies on PER_PAY_PROPOSAL_COMPONENTS

Line 2090: from per_pay_proposal_components

2086: -- Cursor which checks for unapproved components
2087: --
2088: Cursor csr_unapproved_components is
2089: select null
2090: from per_pay_proposal_components
2091: where pay_proposal_id = p_pay_proposal_id
2092: and business_group_id + 0 = p_business_group_id
2093: and approved = 'N';
2094: --

Line 2342: from per_pay_proposal_components

2338: -- Define a cursor to check for unapproved componnets
2339: --
2340: cursor csr_unapproved_components is
2341: select null
2342: from per_pay_proposal_components
2343: where pay_proposal_id = p_pay_proposal_id
2344: and approved = 'N';
2345: --
2346: -- Define a cursor which gets the latest approved salary_proposal.

Line 2366: from per_pay_proposal_components

2362: -- should fail.
2363: --
2364: cursor csr_component_exists is
2365: select null
2366: from per_pay_proposal_components
2367: where pay_proposal_id = p_pay_proposal_id;
2368:
2369: --
2370: begin