APPS.HR_MAINTAIN_PROPOSAL_API dependencies on PER_PAY_PROPOSAL_COMPONENTS

Line 2018: from per_pay_proposal_components ppc

2014: --
2015: cursor components is
2016: select ppc.component_id
2017: , ppc.object_version_number
2018: from per_pay_proposal_components ppc
2019: where ppc.pay_proposal_id=p_pay_proposal_id
2020: and ppc.business_group_id=p_business_group_id;
2021:
2022: cursor elements is

Line 2290: l_component_id per_pay_proposal_components.component_id%TYPE;

2286: p_validate in boolean
2287: ) is
2288: --
2289: l_proc varchar2(72) := g_package||'insert_proposal_component';
2290: l_component_id per_pay_proposal_components.component_id%TYPE;
2291: l_object_version_number per_pay_proposal_components.object_version_number%TYPE;
2292: --
2293: begin
2294: hr_utility.set_location('Entering:'||l_proc,5);

Line 2291: l_object_version_number per_pay_proposal_components.object_version_number%TYPE;

2287: ) is
2288: --
2289: l_proc varchar2(72) := g_package||'insert_proposal_component';
2290: l_component_id per_pay_proposal_components.component_id%TYPE;
2291: l_object_version_number per_pay_proposal_components.object_version_number%TYPE;
2292: --
2293: begin
2294: hr_utility.set_location('Entering:'||l_proc,5);
2295: --

Line 2510: l_object_version_number per_pay_proposal_components.object_version_number%TYPE;

2506: p_validate in boolean
2507: ) is
2508: --
2509: l_proc varchar2(72) := g_package||'update_proposal_component';
2510: l_object_version_number per_pay_proposal_components.object_version_number%TYPE;
2511: l_temp_ovn number := p_object_version_number;
2512: --
2513: begin
2514: hr_utility.set_location('Entering:'||l_proc,10);

Line 3249: from per_pay_proposal_components ppc

3245: --
3246: cursor components(p_pay_proposal_id number, p_business_group_id number) is
3247: select ppc.component_id
3248: , ppc.object_version_number
3249: from per_pay_proposal_components ppc
3250: where ppc.pay_proposal_id=p_pay_proposal_id
3251: and ppc.business_group_id=p_business_group_id;
3252: --
3253: begin