DBA Data[Home] [Help]

APPS.PER_PYP_BUS dependencies on PER_PAY_PROPOSAL_COMPONENTS

Line 2233: from per_pay_proposal_components

2229: -- Cursor which checks for unapproved components
2230: --
2231: Cursor csr_unapproved_components is
2232: select null
2233: from per_pay_proposal_components
2234: where pay_proposal_id = p_pay_proposal_id
2235: and business_group_id + 0 = p_business_group_id
2236: and approved = 'N';
2237: --

Line 2485: from per_pay_proposal_components

2481: -- Define a cursor to check for unapproved componnets
2482: --
2483: cursor csr_unapproved_components is
2484: select null
2485: from per_pay_proposal_components
2486: where pay_proposal_id = p_pay_proposal_id
2487: and approved = 'N';
2488: --
2489: -- Define a cursor which gets the latest approved salary_proposal.

Line 2509: from per_pay_proposal_components

2505: -- should fail.
2506: --
2507: cursor csr_component_exists is
2508: select null
2509: from per_pay_proposal_components
2510: where pay_proposal_id = p_pay_proposal_id;
2511:
2512: --
2513: begin