APPS.HR_MAINTAIN_PROPOSAL_API dependencies on PER_PAY_PROPOSAL_COMPONENTS

Line 2017: from per_pay_proposal_components ppc

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

Line 2288: l_component_id per_pay_proposal_components.component_id%TYPE;

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

Line 2289: l_object_version_number per_pay_proposal_components.object_version_number%TYPE;

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

Line 2508: l_object_version_number per_pay_proposal_components.object_version_number%TYPE;

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

Line 3247: from per_pay_proposal_components ppc

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