eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_PAY_CALC dependencies on GHR_PA_REQUESTS

Line 24: ,p_prd IN ghr_pa_requests.pay_rate_determinant%type

20: --
21:
22: FUNCTION get_open_pay_range (p_position_id IN hr_all_positions_f.position_id%TYPE
23: ,p_person_id IN per_all_people_f.person_id%type
24: ,p_prd IN ghr_pa_requests.pay_rate_determinant%type
25: ,p_pa_request_id IN ghr_pa_requests.pa_request_id%type
26: ,p_effective_date IN date)
27: RETURN BOOLEAN IS
28: --

Line 25: ,p_pa_request_id IN ghr_pa_requests.pa_request_id%type

21:
22: FUNCTION get_open_pay_range (p_position_id IN hr_all_positions_f.position_id%TYPE
23: ,p_person_id IN per_all_people_f.person_id%type
24: ,p_prd IN ghr_pa_requests.pay_rate_determinant%type
25: ,p_pa_request_id IN ghr_pa_requests.pa_request_id%type
26: ,p_effective_date IN date)
27: RETURN BOOLEAN IS
28: --
29: l_pos_ei_data per_position_extra_info%ROWTYPE;

Line 171: l_ghr_pa_request_rec ghr_pa_requests%ROWTYPE;

167: l_second_noa_code ghr_nature_of_actions.code%TYPE;
168: l_pay_plan VARCHAR2(30);
169: l_prd VARCHAR2(30);
170: --
171: l_ghr_pa_request_rec ghr_pa_requests%ROWTYPE;
172: --
173: BEGIN
174: -- If 'Correction' then use second NOA
175: IF p_first_noa_code = '002' THEN

Line 224: ,p_first_action_la_code1 IN ghr_pa_requests.first_action_la_code1%TYPE

220: ,p_position_id IN hr_all_positions_f.position_id%TYPE
221: ,p_noa_family_code IN ghr_families.noa_family_code%TYPE
222: ,p_noa_code IN ghr_nature_of_actions.code%TYPE
223: ,p_second_noa_code IN ghr_nature_of_actions.code%TYPE
224: ,p_first_action_la_code1 IN ghr_pa_requests.first_action_la_code1%TYPE
225: ,p_effective_date IN DATE
226: ,p_pay_rate_determinant IN VARCHAR2
227: ,p_pay_plan IN VARCHAR2
228: ,p_grade_or_level IN VARCHAR2

Line 613: CURSOR c_get_rpa_details(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS

609: and pei_information_category = 'GHR_US_RETAINED_GRADE'
610: and c_effective_date BETWEEN NVL(fnd_date.canonical_to_date(pei_information1),c_effective_date)
611: AND NVL(fnd_date.canonical_to_date(pei_information2),c_effective_date);
612:
613: CURSOR c_get_rpa_details(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
614: SELECT pa_notification_id, to_step_or_rate
615: FROM ghr_pa_requests
616: WHERE pa_request_id = c_pa_request_id;
617:

Line 615: FROM ghr_pa_requests

611: AND NVL(fnd_date.canonical_to_date(pei_information2),c_effective_date);
612:
613: CURSOR c_get_rpa_details(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
614: SELECT pa_notification_id, to_step_or_rate
615: FROM ghr_pa_requests
616: WHERE pa_request_id = c_pa_request_id;
617:
618: l_true_or_false BOOLEAN := FALSE;
619: l_effective_date DATE;

Line 623: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;

619: l_effective_date DATE;
620:
621: -- Bug 3021003
622: l_session ghr_history_api.g_session_var_type;
623: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;
624: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%type;
625: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
626: l_ia_effective_date ghr_pa_requests.effective_date%type;
627: l_ia_retro_first_noa ghr_pa_requests.first_noa_code%type;

Line 624: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%type;

620:
621: -- Bug 3021003
622: l_session ghr_history_api.g_session_var_type;
623: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;
624: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%type;
625: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
626: l_ia_effective_date ghr_pa_requests.effective_date%type;
627: l_ia_retro_first_noa ghr_pa_requests.first_noa_code%type;
628: l_ia_retro_second_noa ghr_pa_requests.second_noa_code%type;

Line 625: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;

621: -- Bug 3021003
622: l_session ghr_history_api.g_session_var_type;
623: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;
624: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%type;
625: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
626: l_ia_effective_date ghr_pa_requests.effective_date%type;
627: l_ia_retro_first_noa ghr_pa_requests.first_noa_code%type;
628: l_ia_retro_second_noa ghr_pa_requests.second_noa_code%type;
629:

Line 626: l_ia_effective_date ghr_pa_requests.effective_date%type;

622: l_session ghr_history_api.g_session_var_type;
623: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;
624: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%type;
625: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
626: l_ia_effective_date ghr_pa_requests.effective_date%type;
627: l_ia_retro_first_noa ghr_pa_requests.first_noa_code%type;
628: l_ia_retro_second_noa ghr_pa_requests.second_noa_code%type;
629:
630: l_retained_pay_plan VARCHAR2(30);

Line 627: l_ia_retro_first_noa ghr_pa_requests.first_noa_code%type;

623: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;
624: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%type;
625: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
626: l_ia_effective_date ghr_pa_requests.effective_date%type;
627: l_ia_retro_first_noa ghr_pa_requests.first_noa_code%type;
628: l_ia_retro_second_noa ghr_pa_requests.second_noa_code%type;
629:
630: l_retained_pay_plan VARCHAR2(30);
631: l_retained_grade VARCHAR2(30);

Line 628: l_ia_retro_second_noa ghr_pa_requests.second_noa_code%type;

624: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%type;
625: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
626: l_ia_effective_date ghr_pa_requests.effective_date%type;
627: l_ia_retro_first_noa ghr_pa_requests.first_noa_code%type;
628: l_ia_retro_second_noa ghr_pa_requests.second_noa_code%type;
629:
630: l_retained_pay_plan VARCHAR2(30);
631: l_retained_grade VARCHAR2(30);
632: l_retained_step_or_rate VARCHAR2(30);

Line 1706: ,p_first_action_la_code1 IN ghr_pa_requests.first_action_la_code1%TYPE

1702: ,p_position_id IN hr_all_positions_f.position_id%TYPE
1703: ,p_noa_family_code IN ghr_families.noa_family_code%TYPE
1704: ,p_noa_code IN ghr_nature_of_actions.code%TYPE
1705: ,p_second_noa_code IN ghr_nature_of_actions.code%TYPE
1706: ,p_first_action_la_code1 IN ghr_pa_requests.first_action_la_code1%TYPE
1707: ,p_effective_date IN DATE
1708: ,p_pay_rate_determinant IN VARCHAR2
1709: ,p_pay_plan IN VARCHAR2
1710: ,p_grade_or_level IN VARCHAR2

Line 1753: l_ghr_pa_request_rec ghr_pa_requests%ROWTYPE;

1749: ,p_calculated OUT NOCOPY BOOLEAN
1750: ,p_open_localityadj_field OUT NOCOPY BOOLEAN
1751: ) IS
1752: --
1753: l_ghr_pa_request_rec ghr_pa_requests%ROWTYPE;
1754: --
1755: l_effective_date DATE;
1756: --
1757: l_position_id hr_all_positions_f.position_id%TYPE;

Line 1761: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;

1757: l_position_id hr_all_positions_f.position_id%TYPE;
1758: l_noa_family_code ghr_families.noa_family_code%TYPE;
1759: l_noa_code ghr_nature_of_actions.code%TYPE;
1760: l_second_noa_code ghr_nature_of_actions.code%TYPE;
1761: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
1762: l_pay_rate_determinant VARCHAR2(30);
1763: l_pay_plan VARCHAR2(30);
1764: l_grade_or_level VARCHAR2(60);
1765: l_step_or_rate VARCHAR2(30);

Line 1816: from ghr_pa_requests

1812:
1813: ----IA Correction Logic.
1814: cursor c_pa_req1 is
1815: select pa_notification_id
1816: from ghr_pa_requests
1817: where pa_request_id = l_ghr_pa_request_rec.altered_pa_request_id;
1818:
1819: l_ia_flag varchar2(30);
1820: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;

Line 1820: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;

1816: from ghr_pa_requests
1817: where pa_request_id = l_ghr_pa_request_rec.altered_pa_request_id;
1818:
1819: l_ia_flag varchar2(30);
1820: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;
1821: l_retro_first_noa ghr_nature_of_actions.code%type;
1822: l_retro_second_noa ghr_nature_of_actions.code%type;
1823:
1824: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;

Line 1824: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;

1820: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;
1821: l_retro_first_noa ghr_nature_of_actions.code%type;
1822: l_retro_second_noa ghr_nature_of_actions.code%type;
1823:
1824: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
1825: l_ia_effective_date ghr_pa_requests.effective_date%type;
1826: l_ia_retro_first_noa ghr_nature_of_actions.code%type;
1827: l_ia_retro_second_noa ghr_nature_of_actions.code%type;
1828: l_old_effective_date date;

Line 1825: l_ia_effective_date ghr_pa_requests.effective_date%type;

1821: l_retro_first_noa ghr_nature_of_actions.code%type;
1822: l_retro_second_noa ghr_nature_of_actions.code%type;
1823:
1824: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
1825: l_ia_effective_date ghr_pa_requests.effective_date%type;
1826: l_ia_retro_first_noa ghr_nature_of_actions.code%type;
1827: l_ia_retro_second_noa ghr_nature_of_actions.code%type;
1828: l_old_effective_date date;
1829: l_old_ret_allow NUMBER;

Line 1836: l_altered_pa_req_id ghr_pa_requests.altered_pa_request_id%type;

1832: l_from_basic_pay NUMBER;
1833: l_from_retention_allowance NUMBER;
1834:
1835: -- Bug 3248061
1836: l_altered_pa_req_id ghr_pa_requests.altered_pa_request_id%type;
1837: -- Bug 3245692
1838: l_from_pay_basis ghr_pa_requests.from_pay_basis%type;
1839:
1840: CURSOR c_get_from_pay_basis(c_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS

Line 1838: l_from_pay_basis ghr_pa_requests.from_pay_basis%type;

1834:
1835: -- Bug 3248061
1836: l_altered_pa_req_id ghr_pa_requests.altered_pa_request_id%type;
1837: -- Bug 3245692
1838: l_from_pay_basis ghr_pa_requests.from_pay_basis%type;
1839:
1840: CURSOR c_get_from_pay_basis(c_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS
1841: SELECT from_pay_basis
1842: FROM ghr_pa_requests

Line 1840: CURSOR c_get_from_pay_basis(c_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS

1836: l_altered_pa_req_id ghr_pa_requests.altered_pa_request_id%type;
1837: -- Bug 3245692
1838: l_from_pay_basis ghr_pa_requests.from_pay_basis%type;
1839:
1840: CURSOR c_get_from_pay_basis(c_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS
1841: SELECT from_pay_basis
1842: FROM ghr_pa_requests
1843: WHERE pa_request_id = c_pa_request_id;
1844:

Line 1842: FROM ghr_pa_requests

1838: l_from_pay_basis ghr_pa_requests.from_pay_basis%type;
1839:
1840: CURSOR c_get_from_pay_basis(c_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS
1841: SELECT from_pay_basis
1842: FROM ghr_pa_requests
1843: WHERE pa_request_id = c_pa_request_id;
1844:
1845: CURSOR c_get_alt_pareq_id(c_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS
1846: SELECT altered_pa_request_id

Line 1845: CURSOR c_get_alt_pareq_id(c_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS

1841: SELECT from_pay_basis
1842: FROM ghr_pa_requests
1843: WHERE pa_request_id = c_pa_request_id;
1844:
1845: CURSOR c_get_alt_pareq_id(c_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS
1846: SELECT altered_pa_request_id
1847: FROM ghr_pa_requests
1848: WHERE pa_request_id = c_pa_request_id;
1849:

Line 1847: FROM ghr_pa_requests

1843: WHERE pa_request_id = c_pa_request_id;
1844:
1845: CURSOR c_get_alt_pareq_id(c_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS
1846: SELECT altered_pa_request_id
1847: FROM ghr_pa_requests
1848: WHERE pa_request_id = c_pa_request_id;
1849:
1850: CURSOR c_get_notification_id(c_alt_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS
1851: SELECT pa_notification_id

Line 1850: CURSOR c_get_notification_id(c_alt_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS

1846: SELECT altered_pa_request_id
1847: FROM ghr_pa_requests
1848: WHERE pa_request_id = c_pa_request_id;
1849:
1850: CURSOR c_get_notification_id(c_alt_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS
1851: SELECT pa_notification_id
1852: FROM ghr_pa_requests
1853: WHERE pa_request_id = c_alt_pa_request_id;
1854: -- End Bug 3248061

Line 1852: FROM ghr_pa_requests

1848: WHERE pa_request_id = c_pa_request_id;
1849:
1850: CURSOR c_get_notification_id(c_alt_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS
1851: SELECT pa_notification_id
1852: FROM ghr_pa_requests
1853: WHERE pa_request_id = c_alt_pa_request_id;
1854: -- End Bug 3248061
1855:
1856: -- Bug#5120116 created the cursor to get assignment id.

Line 1996: l_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family(p_second_noa_code);

1992: ,p_sf52_data_result => l_ghr_pa_request_rec
1993: ,p_called_from => 'FROM_PAYCAL');
1994:
1995: l_position_id := NVL(p_position_id,l_ghr_pa_request_rec.to_position_id);
1996: l_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family(p_second_noa_code);
1997: l_noa_code := p_second_noa_code;
1998: l_second_noa_code := NULL;
1999: l_first_action_la_code1 := NVL(p_first_action_la_code1 ,l_ghr_pa_request_rec.first_action_la_code1);
2000: l_pay_rate_determinant := NVL(p_pay_rate_determinant ,l_ghr_pa_request_rec.pay_rate_determinant);

Line 2016: -- For correction actions take pay basis from ghr_pa_requests table itself.

2012: l_current_basic_pay := NVL(p_current_basic_pay ,l_ghr_pa_request_rec.from_basic_pay);
2013: l_current_adj_basic_pay := NVL(p_current_adj_basic_pay ,l_ghr_pa_request_rec.from_adj_basic_pay);
2014: l_current_step_or_rate := NVL(p_current_step_or_rate ,l_ghr_pa_request_rec.from_step_or_rate);
2015:
2016: -- For correction actions take pay basis from ghr_pa_requests table itself.
2017: FOR ctr_from_pay_basis IN c_get_from_pay_basis(p_pa_request_id) LOOP
2018: l_from_pay_basis := ctr_from_pay_basis.from_pay_basis;
2019: END LOOP;
2020:

Line 2280: l_second_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family(p_second_noa_code);

2276: -- 892/893 892/893 Run Pac Calc twice!!
2277: --
2278: -- Firstly if no second NOA then nothing to worry about!!
2279: IF l_second_noa_code IS NOT NULL THEN
2280: l_second_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family(p_second_noa_code);
2281: --
2282: IF l_second_noa_family_code IN ('APP','CHG_DUTY_STATION','CONV_APP','EXT_NTE','POS_CHG'
2283: ,'REALIGNMENT','REASSIGNMENT', 'RETURN_TO_DUTY')
2284: AND (l_noa_code IN ('892','893')

Line 2351: l_pay_calc_data.personnel_system_indicator := ghr_pa_requests_pkg.get_personnel_system_indicator

2347: --
2348: validate_in_data(l_pay_calc_data);
2349: --
2350: -- Bug#5482191 Fetch the PSI Value
2351: l_pay_calc_data.personnel_system_indicator := ghr_pa_requests_pkg.get_personnel_system_indicator
2352: (l_pay_calc_data.position_id,l_pay_calc_data.effective_date); -- MSL Percentage Changes Madhuri
2353: -- Bug#4758111 PRD 2 Processing.
2354: --- if nvl(ghr_msl_pkg.g_ses_msl_process,'N') <> 'Y' then
2355: if p_open_range_out_basic_pay is null then

Line 2480: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop(l_assignment_id,

2476: LOOP
2477: l_assignment_id := asg_rec.assignment_id;
2478: exit;
2479: END LOOP;
2480: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop(l_assignment_id,
2481: l_pay_calc_data.effective_date);
2482:
2483: -- Bug#5349609 If capped other pay is null, get the other pay value.
2484: IF l_capped_other_pay is NULL THEN

Line 3503: p_effective_date IN ghr_pa_requests.effective_date%type,

3499: RAISE;
3500: END get_open_pay_table_values;
3501:
3502: FUNCTION get_pay_basis(
3503: p_effective_date IN ghr_pa_requests.effective_date%type,
3504: p_pa_request_id IN ghr_pa_requests.pa_request_id%type,
3505: p_person_id IN ghr_pa_requests.person_id%type
3506: ) RETURN ghr_pa_requests.from_pay_basis%type
3507: IS

Line 3504: p_pa_request_id IN ghr_pa_requests.pa_request_id%type,

3500: END get_open_pay_table_values;
3501:
3502: FUNCTION get_pay_basis(
3503: p_effective_date IN ghr_pa_requests.effective_date%type,
3504: p_pa_request_id IN ghr_pa_requests.pa_request_id%type,
3505: p_person_id IN ghr_pa_requests.person_id%type
3506: ) RETURN ghr_pa_requests.from_pay_basis%type
3507: IS
3508: l_asg_ei_data per_assignment_extra_info%rowtype;

Line 3505: p_person_id IN ghr_pa_requests.person_id%type

3501:
3502: FUNCTION get_pay_basis(
3503: p_effective_date IN ghr_pa_requests.effective_date%type,
3504: p_pa_request_id IN ghr_pa_requests.pa_request_id%type,
3505: p_person_id IN ghr_pa_requests.person_id%type
3506: ) RETURN ghr_pa_requests.from_pay_basis%type
3507: IS
3508: l_asg_ei_data per_assignment_extra_info%rowtype;
3509: l_prd per_assignment_extra_info.aei_information6%type;

Line 3506: ) RETURN ghr_pa_requests.from_pay_basis%type

3502: FUNCTION get_pay_basis(
3503: p_effective_date IN ghr_pa_requests.effective_date%type,
3504: p_pa_request_id IN ghr_pa_requests.pa_request_id%type,
3505: p_person_id IN ghr_pa_requests.person_id%type
3506: ) RETURN ghr_pa_requests.from_pay_basis%type
3507: IS
3508: l_asg_ei_data per_assignment_extra_info%rowtype;
3509: l_prd per_assignment_extra_info.aei_information6%type;
3510: l_dummy VARCHAR2(30);

Line 3512: l_from_position_id ghr_pa_requests.from_position_id%type;

3508: l_asg_ei_data per_assignment_extra_info%rowtype;
3509: l_prd per_assignment_extra_info.aei_information6%type;
3510: l_dummy VARCHAR2(30);
3511: l_assignment_id per_assignments_f.assignment_id%type;
3512: l_from_position_id ghr_pa_requests.from_position_id%type;
3513: l_from_pay_basis ghr_pa_requests.from_pay_basis%type;
3514: l_pos_ei_grade_data per_position_extra_info%rowtype;
3515:
3516: CURSOR get_asgn_pos(c_person_id IN ghr_pa_requests.person_id%type, c_effective_date IN ghr_pa_requests.effective_date%type) IS

Line 3513: l_from_pay_basis ghr_pa_requests.from_pay_basis%type;

3509: l_prd per_assignment_extra_info.aei_information6%type;
3510: l_dummy VARCHAR2(30);
3511: l_assignment_id per_assignments_f.assignment_id%type;
3512: l_from_position_id ghr_pa_requests.from_position_id%type;
3513: l_from_pay_basis ghr_pa_requests.from_pay_basis%type;
3514: l_pos_ei_grade_data per_position_extra_info%rowtype;
3515:
3516: CURSOR get_asgn_pos(c_person_id IN ghr_pa_requests.person_id%type, c_effective_date IN ghr_pa_requests.effective_date%type) IS
3517: SELECT paf.assignment_id, paf.position_id

Line 3516: CURSOR get_asgn_pos(c_person_id IN ghr_pa_requests.person_id%type, c_effective_date IN ghr_pa_requests.effective_date%type) IS

3512: l_from_position_id ghr_pa_requests.from_position_id%type;
3513: l_from_pay_basis ghr_pa_requests.from_pay_basis%type;
3514: l_pos_ei_grade_data per_position_extra_info%rowtype;
3515:
3516: CURSOR get_asgn_pos(c_person_id IN ghr_pa_requests.person_id%type, c_effective_date IN ghr_pa_requests.effective_date%type) IS
3517: SELECT paf.assignment_id, paf.position_id
3518: FROM per_assignments_f paf
3519: WHERE paf.person_id = c_person_id
3520: AND trunc(nvl(c_effective_date,sysdate))between paf.effective_start_date and paf.effective_end_date

Line 3533: ghr_pa_requests_pkg.get_SF52_asg_ddf_details

3529: END LOOP;
3530:
3531: -- Get Assignment extra info records
3532: IF l_assignment_id IS NOT NULL THEN
3533: ghr_pa_requests_pkg.get_SF52_asg_ddf_details
3534: (p_assignment_id => l_assignment_id
3535: ,p_date_effective => p_effective_date
3536: ,p_tenure => l_dummy
3537: ,p_annuitant_indicator => l_dummy

Line 3547: ghr_pa_requests_pkg.temp_step_true(p_pa_request_id) THEN

3543: -- If PRD In 'A','B','E','F','U','V'
3544: IF l_prd IN ('A','B','E','F','U','V') THEN
3545: -- If PRD in 'A','B','E','F' and having temporary promotion step, get from position extra info
3546: IF l_prd IN ('A','B','E','F') AND
3547: ghr_pa_requests_pkg.temp_step_true(p_pa_request_id) THEN
3548: ghr_history_fetch.fetch_positionei(
3549: p_position_id => l_from_position_id,
3550: p_information_type => 'GHR_US_POS_VALID_GRADE',
3551: p_date_effective => nvl(p_effective_date,trunc(sysdate)),

Line 3555: l_from_pay_basis := ghr_pa_requests_pkg.get_upd34_pay_basis

3551: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
3552: p_pos_ei_data => l_pos_ei_grade_data);
3553: l_from_pay_basis := l_pos_ei_grade_data.poei_information6;
3554: ELSE
3555: l_from_pay_basis := ghr_pa_requests_pkg.get_upd34_pay_basis
3556: (p_person_id => p_person_id
3557: ,p_position_id => l_from_position_id
3558: ,p_prd => l_prd
3559: ,p_noa_code => null

Line 3627: CURSOR get_asgn_pos (c_person_id IN ghr_pa_requests.person_id%type,

3623: l_value varchar2(60);
3624: l_multi_error_flag BOOLEAN;
3625: l_gm_unadjd_basic_pay Number;
3626:
3627: CURSOR get_asgn_pos (c_person_id IN ghr_pa_requests.person_id%type,
3628: c_effective_date IN ghr_pa_requests.effective_date%type)
3629: IS
3630: SELECT paf.assignment_id
3631: FROM per_assignments_f paf

Line 3628: c_effective_date IN ghr_pa_requests.effective_date%type)

3624: l_multi_error_flag BOOLEAN;
3625: l_gm_unadjd_basic_pay Number;
3626:
3627: CURSOR get_asgn_pos (c_person_id IN ghr_pa_requests.person_id%type,
3628: c_effective_date IN ghr_pa_requests.effective_date%type)
3629: IS
3630: SELECT paf.assignment_id
3631: FROM per_assignments_f paf
3632: WHERE paf.person_id = c_person_id

Line 3804: CURSOR get_asgn_pos (c_person_id IN ghr_pa_requests.person_id%type,

3800: l_value varchar2(60);
3801: l_multi_error_flag BOOLEAN;
3802: l_gm_unadjd_basic_pay Number;
3803:
3804: CURSOR get_asgn_pos (c_person_id IN ghr_pa_requests.person_id%type,
3805: c_effective_date IN ghr_pa_requests.effective_date%type)
3806: IS
3807: SELECT paf.assignment_id
3808: FROM per_assignments_f paf

Line 3805: c_effective_date IN ghr_pa_requests.effective_date%type)

3801: l_multi_error_flag BOOLEAN;
3802: l_gm_unadjd_basic_pay Number;
3803:
3804: CURSOR get_asgn_pos (c_person_id IN ghr_pa_requests.person_id%type,
3805: c_effective_date IN ghr_pa_requests.effective_date%type)
3806: IS
3807: SELECT paf.assignment_id
3808: FROM per_assignments_f paf
3809: WHERE paf.person_id = c_person_id

Line 4171: l_from_position_id ghr_pa_requests.from_position_id%type;

4167: l_pos_ei_valid_grade per_position_extra_info%ROWTYPE;
4168: -- 7046241
4169:
4170: --Bug# 9258929
4171: l_from_position_id ghr_pa_requests.from_position_id%type;
4172: --Bug # 10368444
4173: l_from_pay_plan ghr_pa_requests.from_pay_plan%type;
4174: l_from_grade_id NUMBER;
4175: l_from_pos_ind VARCHAR2(30);

Line 4173: l_from_pay_plan ghr_pa_requests.from_pay_plan%type;

4169:
4170: --Bug# 9258929
4171: l_from_position_id ghr_pa_requests.from_position_id%type;
4172: --Bug # 10368444
4173: l_from_pay_plan ghr_pa_requests.from_pay_plan%type;
4174: l_from_grade_id NUMBER;
4175: l_from_pos_ind VARCHAR2(30);
4176: l_to_pos_ind VARCHAR2(30);
4177: l_equivalent_pay_plan ghr_pay_plans.equivalent_pay_plan%type;

Line 4187: cursor get_asgn_pos(c_person_id IN ghr_pa_requests.person_id%type,

4183: select equivalent_pay_plan
4184: from ghr_pay_plans
4185: where pay_plan = p_pay_plan;
4186:
4187: cursor get_asgn_pos(c_person_id IN ghr_pa_requests.person_id%type,
4188: c_effective_date IN ghr_pa_requests.effective_date%type)
4189: is
4190: select paf.position_id,
4191: paf.grade_id

Line 4188: c_effective_date IN ghr_pa_requests.effective_date%type)

4184: from ghr_pay_plans
4185: where pay_plan = p_pay_plan;
4186:
4187: cursor get_asgn_pos(c_person_id IN ghr_pa_requests.person_id%type,
4188: c_effective_date IN ghr_pa_requests.effective_date%type)
4189: is
4190: select paf.position_id,
4191: paf.grade_id
4192: from per_all_assignments_f paf

Line 4202: from ghr_pa_requests

4198: cursor get_pa_req_det(p_pa_request_id in number)
4199: is
4200: select from_position_id,
4201: from_pay_plan --Added for Bug # 10368444
4202: from ghr_pa_requests
4203: where pa_request_id = p_pa_request_id;
4204:
4205: cursor c_grade_kff (grd_id number) is
4206: select gdf.segment1,

Line 4616: l_from_pos_ind := ghr_pa_requests_pkg.get_personnel_system_indicator(l_from_position_id,p_pay_calc_data.effective_date);

4612: loop
4613: l_equivalent_pay_plan := c_equi_pay_plan.equivalent_pay_plan;
4614: end loop;
4615:
4616: l_from_pos_ind := ghr_pa_requests_pkg.get_personnel_system_indicator(l_from_position_id,p_pay_calc_data.effective_date);
4617:
4618: hr_utility.set_location('l_from_pos_ind'||l_from_pos_ind,1000);
4619:
4620: hr_utility.set_location('l_from_pay_plan'||l_from_pay_plan,1000);

Line 4626: l_to_pos_ind := ghr_pa_requests_pkg.get_personnel_system_indicator(nvl(p_pay_calc_data.position_id,l_from_position_id),p_pay_calc_data.effective_date);

4622:
4623: hr_utility.set_location('l_pay_plan'||l_pay_plan,1000);
4624: hr_utility.set_location('p_pay_calc_data.pay_rate_determinant'||p_pay_calc_data.pay_rate_determinant,1000);
4625:
4626: l_to_pos_ind := ghr_pa_requests_pkg.get_personnel_system_indicator(nvl(p_pay_calc_data.position_id,l_from_position_id),p_pay_calc_data.effective_date);
4627: --Bug # 9258929
4628:
4629: -- Bug# 4866952 Added the new pay calculation method for Pay Adjustment actions
4630: -- Processed after 01-MAY-2005

Line 5330: ,p_prd IN ghr_pa_requests.pay_rate_determinant%type

5326: ,p_effective_date IN DATE
5327: ,p_basic_pay IN NUMBER
5328: ,p_adj_basic_pay IN NUMBER
5329: ,p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
5330: ,p_prd IN ghr_pa_requests.pay_rate_determinant%type
5331: ,p_pay_basis IN VARCHAR2
5332: ,p_person_id IN per_people_f.person_id%TYPE
5333: ,p_award_amount OUT NOCOPY NUMBER
5334: ,p_award_salary OUT NOCOPY NUMBER

Line 5369: l_psi := ghr_pa_requests_pkg.get_personnel_system_indicator(p_position_id,p_effective_date);

5365: WHERE utb.user_table_name = p_user_table_name;
5366:
5367: BEGIN
5368: hr_utility.set_location('Entering ...'|| l_proc,100);
5369: l_psi := ghr_pa_requests_pkg.get_personnel_system_indicator(p_position_id,p_effective_date);
5370:
5371: hr_utility.set_location('personnel system ...'|| l_psi,101);
5372:
5373: IF l_psi <> '00' THEN --for NSPS