APPS.PER_PAY_PROPOSALS_POPULATE dependencies on PER_PAY_PROPOSALS

Line 1: PACKAGE BODY PER_PAY_PROPOSALS_POPULATE AS

1: PACKAGE BODY PER_PAY_PROPOSALS_POPULATE AS
2: /* $Header: pepaprpo.pkb 120.1.12020000.2 2012/07/05 03:07:07 amnaraya ship $ */
3: g_package varchar2(33) := 'per_pay_proposals_populate.';
4: g_debug boolean := hr_utility.debug_enabled;
5: --------------------------------------------------------------------------

Line 3: g_package varchar2(33) := 'per_pay_proposals_populate.';

1: PACKAGE BODY PER_PAY_PROPOSALS_POPULATE AS
2: /* $Header: pepaprpo.pkb 120.1.12020000.2 2012/07/05 03:07:07 amnaraya ship $ */
3: g_package varchar2(33) := 'per_pay_proposals_populate.';
4: g_debug boolean := hr_utility.debug_enabled;
5: --------------------------------------------------------------------------
6: /* Procedure to get the grade that a person is on given the
7: date, assginment_id and business_group_id. If the person

Line 386: from per_pay_proposals pro

382:
383: CURSOR previous_pay is
384: select pro.proposed_salary_n
385: , pro.change_date
386: from per_pay_proposals pro
387: where pro.assignment_id = p_assignment_id
388: and pro.change_date =(select max(pro2.change_date)
389: from per_pay_proposals pro2
390: where pro2.assignment_id = p_assignment_id

Line 389: from per_pay_proposals pro2

385: , pro.change_date
386: from per_pay_proposals pro
387: where pro.assignment_id = p_assignment_id
388: and pro.change_date =(select max(pro2.change_date)
389: from per_pay_proposals pro2
390: where pro2.assignment_id = p_assignment_id
391: and pro2.change_date 392:
393:

Line 676: END PER_PAY_PROPOSALS_POPULATE;

672: end get_norm_hours;
673:
674:
675: ------------------------------------------------------------------------------
676: END PER_PAY_PROPOSALS_POPULATE;