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 1652: ,p_first_action_la_code1 IN ghr_pa_requests.first_action_la_code1%TYPE

1648: ,p_position_id IN hr_all_positions_f.position_id%TYPE
1649: ,p_noa_family_code IN ghr_families.noa_family_code%TYPE
1650: ,p_noa_code IN ghr_nature_of_actions.code%TYPE
1651: ,p_second_noa_code IN ghr_nature_of_actions.code%TYPE
1652: ,p_first_action_la_code1 IN ghr_pa_requests.first_action_la_code1%TYPE
1653: ,p_effective_date IN DATE
1654: ,p_pay_rate_determinant IN VARCHAR2
1655: ,p_pay_plan IN VARCHAR2
1656: ,p_grade_or_level IN VARCHAR2

Line 1699: l_ghr_pa_request_rec ghr_pa_requests%ROWTYPE;

1695: ,p_calculated OUT NOCOPY BOOLEAN
1696: ,p_open_localityadj_field OUT NOCOPY BOOLEAN
1697: ) IS
1698: --
1699: l_ghr_pa_request_rec ghr_pa_requests%ROWTYPE;
1700: --
1701: l_effective_date DATE;
1702: --
1703: l_position_id hr_all_positions_f.position_id%TYPE;

Line 1707: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;

1703: l_position_id hr_all_positions_f.position_id%TYPE;
1704: l_noa_family_code ghr_families.noa_family_code%TYPE;
1705: l_noa_code ghr_nature_of_actions.code%TYPE;
1706: l_second_noa_code ghr_nature_of_actions.code%TYPE;
1707: l_first_action_la_code1 ghr_pa_requests.first_action_la_code1%TYPE;
1708: l_pay_rate_determinant VARCHAR2(30);
1709: l_pay_plan VARCHAR2(30);
1710: l_grade_or_level VARCHAR2(60);
1711: l_step_or_rate VARCHAR2(30);

Line 1762: from ghr_pa_requests

1758:
1759: ----IA Correction Logic.
1760: cursor c_pa_req1 is
1761: select pa_notification_id
1762: from ghr_pa_requests
1763: where pa_request_id = l_ghr_pa_request_rec.altered_pa_request_id;
1764:
1765: l_ia_flag varchar2(30);
1766: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;

Line 1766: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;

1762: from ghr_pa_requests
1763: where pa_request_id = l_ghr_pa_request_rec.altered_pa_request_id;
1764:
1765: l_ia_flag varchar2(30);
1766: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;
1767: l_retro_first_noa ghr_nature_of_actions.code%type;
1768: l_retro_second_noa ghr_nature_of_actions.code%type;
1769:
1770: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;

Line 1770: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;

1766: l_pa_notification_id ghr_pa_requests.pa_notification_id%type;
1767: l_retro_first_noa ghr_nature_of_actions.code%type;
1768: l_retro_second_noa ghr_nature_of_actions.code%type;
1769:
1770: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
1771: l_ia_effective_date ghr_pa_requests.effective_date%type;
1772: l_ia_retro_first_noa ghr_nature_of_actions.code%type;
1773: l_ia_retro_second_noa ghr_nature_of_actions.code%type;
1774: l_old_effective_date date;

Line 1771: l_ia_effective_date ghr_pa_requests.effective_date%type;

1767: l_retro_first_noa ghr_nature_of_actions.code%type;
1768: l_retro_second_noa ghr_nature_of_actions.code%type;
1769:
1770: l_retro_pa_request_id ghr_pa_requests.pa_request_id%type;
1771: l_ia_effective_date ghr_pa_requests.effective_date%type;
1772: l_ia_retro_first_noa ghr_nature_of_actions.code%type;
1773: l_ia_retro_second_noa ghr_nature_of_actions.code%type;
1774: l_old_effective_date date;
1775: l_old_ret_allow NUMBER;

Line 1782: l_altered_pa_req_id ghr_pa_requests.altered_pa_request_id%type;

1778: l_from_basic_pay NUMBER;
1779: l_from_retention_allowance NUMBER;
1780:
1781: -- Bug 3248061
1782: l_altered_pa_req_id ghr_pa_requests.altered_pa_request_id%type;
1783: -- Bug 3245692
1784: l_from_pay_basis ghr_pa_requests.from_pay_basis%type;
1785:
1786: CURSOR c_get_from_pay_basis(c_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS

Line 1784: l_from_pay_basis ghr_pa_requests.from_pay_basis%type;

1780:
1781: -- Bug 3248061
1782: l_altered_pa_req_id ghr_pa_requests.altered_pa_request_id%type;
1783: -- Bug 3245692
1784: l_from_pay_basis ghr_pa_requests.from_pay_basis%type;
1785:
1786: CURSOR c_get_from_pay_basis(c_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS
1787: SELECT from_pay_basis
1788: FROM ghr_pa_requests

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

1782: l_altered_pa_req_id ghr_pa_requests.altered_pa_request_id%type;
1783: -- Bug 3245692
1784: l_from_pay_basis ghr_pa_requests.from_pay_basis%type;
1785:
1786: CURSOR c_get_from_pay_basis(c_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS
1787: SELECT from_pay_basis
1788: FROM ghr_pa_requests
1789: WHERE pa_request_id = c_pa_request_id;
1790:

Line 1788: FROM ghr_pa_requests

1784: l_from_pay_basis ghr_pa_requests.from_pay_basis%type;
1785:
1786: CURSOR c_get_from_pay_basis(c_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS
1787: SELECT from_pay_basis
1788: FROM ghr_pa_requests
1789: WHERE pa_request_id = c_pa_request_id;
1790:
1791: CURSOR c_get_alt_pareq_id(c_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS
1792: SELECT altered_pa_request_id

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

1787: SELECT from_pay_basis
1788: FROM ghr_pa_requests
1789: WHERE pa_request_id = c_pa_request_id;
1790:
1791: CURSOR c_get_alt_pareq_id(c_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS
1792: SELECT altered_pa_request_id
1793: FROM ghr_pa_requests
1794: WHERE pa_request_id = c_pa_request_id;
1795:

Line 1793: FROM ghr_pa_requests

1789: WHERE pa_request_id = c_pa_request_id;
1790:
1791: CURSOR c_get_alt_pareq_id(c_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS
1792: SELECT altered_pa_request_id
1793: FROM ghr_pa_requests
1794: WHERE pa_request_id = c_pa_request_id;
1795:
1796: CURSOR c_get_notification_id(c_alt_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS
1797: SELECT pa_notification_id

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

1792: SELECT altered_pa_request_id
1793: FROM ghr_pa_requests
1794: WHERE pa_request_id = c_pa_request_id;
1795:
1796: CURSOR c_get_notification_id(c_alt_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS
1797: SELECT pa_notification_id
1798: FROM ghr_pa_requests
1799: WHERE pa_request_id = c_alt_pa_request_id;
1800: -- End Bug 3248061

Line 1798: FROM ghr_pa_requests

1794: WHERE pa_request_id = c_pa_request_id;
1795:
1796: CURSOR c_get_notification_id(c_alt_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS
1797: SELECT pa_notification_id
1798: FROM ghr_pa_requests
1799: WHERE pa_request_id = c_alt_pa_request_id;
1800: -- End Bug 3248061
1801:
1802: -- Bug#5120116 created the cursor to get assignment id.

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

1904: ,p_sf52_data_result => l_ghr_pa_request_rec
1905: ,p_called_from => 'FROM_PAYCAL');
1906:
1907: l_position_id := NVL(p_position_id,l_ghr_pa_request_rec.to_position_id);
1908: l_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family(p_second_noa_code);
1909: l_noa_code := p_second_noa_code;
1910: l_second_noa_code := NULL;
1911: l_first_action_la_code1 := NVL(p_first_action_la_code1 ,l_ghr_pa_request_rec.first_action_la_code1);
1912: l_pay_rate_determinant := NVL(p_pay_rate_determinant ,l_ghr_pa_request_rec.pay_rate_determinant);

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

1924: l_current_basic_pay := NVL(p_current_basic_pay ,l_ghr_pa_request_rec.from_basic_pay);
1925: l_current_adj_basic_pay := NVL(p_current_adj_basic_pay ,l_ghr_pa_request_rec.from_adj_basic_pay);
1926: l_current_step_or_rate := NVL(p_current_step_or_rate ,l_ghr_pa_request_rec.from_step_or_rate);
1927:
1928: -- For correction actions take pay basis from ghr_pa_requests table itself.
1929: FOR ctr_from_pay_basis IN c_get_from_pay_basis(p_pa_request_id) LOOP
1930: l_from_pay_basis := ctr_from_pay_basis.from_pay_basis;
1931: END LOOP;
1932:

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

2188: -- 892/893 892/893 Run Pac Calc twice!!
2189: --
2190: -- Firstly if no second NOA then nothing to worry about!!
2191: IF l_second_noa_code IS NOT NULL THEN
2192: l_second_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family(p_second_noa_code);
2193: --
2194: IF l_second_noa_family_code IN ('APP','CHG_DUTY_STATION','CONV_APP','EXT_NTE','POS_CHG'
2195: ,'REALIGNMENT','REASSIGNMENT', 'RETURN_TO_DUTY')
2196: AND (l_noa_code IN ('892','893')

Line 2251: l_pay_calc_data.personnel_system_indicator := ghr_pa_requests_pkg.get_personnel_system_indicator

2247: --
2248: validate_in_data(l_pay_calc_data);
2249: --
2250: -- Bug#5482191 Fetch the PSI Value
2251: l_pay_calc_data.personnel_system_indicator := ghr_pa_requests_pkg.get_personnel_system_indicator
2252: (l_pay_calc_data.position_id,l_pay_calc_data.effective_date); -- MSL Percentage Changes Madhuri
2253: -- Bug#4758111 PRD 2 Processing.
2254: --- if nvl(ghr_msl_pkg.g_ses_msl_process,'N') <> 'Y' then
2255: if p_open_range_out_basic_pay is null and l_noa_code <> '890' then

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

2328: LOOP
2329: l_assignment_id := asg_rec.assignment_id;
2330: exit;
2331: END LOOP;
2332: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop(l_assignment_id,
2333: l_pay_calc_data.effective_date);
2334:
2335: -- Bug#5349609 If capped other pay is null, get the other pay value.
2336: IF l_capped_other_pay is NULL THEN

Line 3289: p_effective_date IN ghr_pa_requests.effective_date%type,

3285: RAISE;
3286: END get_open_pay_table_values;
3287:
3288: FUNCTION get_pay_basis(
3289: p_effective_date IN ghr_pa_requests.effective_date%type,
3290: p_pa_request_id IN ghr_pa_requests.pa_request_id%type,
3291: p_person_id IN ghr_pa_requests.person_id%type
3292: ) RETURN ghr_pa_requests.from_pay_basis%type
3293: IS

Line 3290: p_pa_request_id IN ghr_pa_requests.pa_request_id%type,

3286: END get_open_pay_table_values;
3287:
3288: FUNCTION get_pay_basis(
3289: p_effective_date IN ghr_pa_requests.effective_date%type,
3290: p_pa_request_id IN ghr_pa_requests.pa_request_id%type,
3291: p_person_id IN ghr_pa_requests.person_id%type
3292: ) RETURN ghr_pa_requests.from_pay_basis%type
3293: IS
3294: l_asg_ei_data per_assignment_extra_info%rowtype;

Line 3291: p_person_id IN ghr_pa_requests.person_id%type

3287:
3288: FUNCTION get_pay_basis(
3289: p_effective_date IN ghr_pa_requests.effective_date%type,
3290: p_pa_request_id IN ghr_pa_requests.pa_request_id%type,
3291: p_person_id IN ghr_pa_requests.person_id%type
3292: ) RETURN ghr_pa_requests.from_pay_basis%type
3293: IS
3294: l_asg_ei_data per_assignment_extra_info%rowtype;
3295: l_prd per_assignment_extra_info.aei_information6%type;

Line 3292: ) RETURN ghr_pa_requests.from_pay_basis%type

3288: FUNCTION get_pay_basis(
3289: p_effective_date IN ghr_pa_requests.effective_date%type,
3290: p_pa_request_id IN ghr_pa_requests.pa_request_id%type,
3291: p_person_id IN ghr_pa_requests.person_id%type
3292: ) RETURN ghr_pa_requests.from_pay_basis%type
3293: IS
3294: l_asg_ei_data per_assignment_extra_info%rowtype;
3295: l_prd per_assignment_extra_info.aei_information6%type;
3296: l_dummy VARCHAR2(30);

Line 3298: l_from_position_id ghr_pa_requests.from_position_id%type;

3294: l_asg_ei_data per_assignment_extra_info%rowtype;
3295: l_prd per_assignment_extra_info.aei_information6%type;
3296: l_dummy VARCHAR2(30);
3297: l_assignment_id per_assignments_f.assignment_id%type;
3298: l_from_position_id ghr_pa_requests.from_position_id%type;
3299: l_from_pay_basis ghr_pa_requests.from_pay_basis%type;
3300: l_pos_ei_grade_data per_position_extra_info%rowtype;
3301:
3302: 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 3299: l_from_pay_basis ghr_pa_requests.from_pay_basis%type;

3295: l_prd per_assignment_extra_info.aei_information6%type;
3296: l_dummy VARCHAR2(30);
3297: l_assignment_id per_assignments_f.assignment_id%type;
3298: l_from_position_id ghr_pa_requests.from_position_id%type;
3299: l_from_pay_basis ghr_pa_requests.from_pay_basis%type;
3300: l_pos_ei_grade_data per_position_extra_info%rowtype;
3301:
3302: 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
3303: SELECT paf.assignment_id, paf.position_id

Line 3302: 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

3298: l_from_position_id ghr_pa_requests.from_position_id%type;
3299: l_from_pay_basis ghr_pa_requests.from_pay_basis%type;
3300: l_pos_ei_grade_data per_position_extra_info%rowtype;
3301:
3302: 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
3303: SELECT paf.assignment_id, paf.position_id
3304: FROM per_assignments_f paf
3305: WHERE paf.person_id = c_person_id
3306: AND trunc(nvl(c_effective_date,sysdate))between paf.effective_start_date and paf.effective_end_date

Line 3319: ghr_pa_requests_pkg.get_SF52_asg_ddf_details

3315: END LOOP;
3316:
3317: -- Get Assignment extra info records
3318: IF l_assignment_id IS NOT NULL THEN
3319: ghr_pa_requests_pkg.get_SF52_asg_ddf_details
3320: (p_assignment_id => l_assignment_id
3321: ,p_date_effective => p_effective_date
3322: ,p_tenure => l_dummy
3323: ,p_annuitant_indicator => l_dummy

Line 3333: ghr_pa_requests_pkg.temp_step_true(p_pa_request_id) THEN

3329: -- If PRD In 'A','B','E','F','U','V'
3330: IF l_prd IN ('A','B','E','F','U','V') THEN
3331: -- If PRD in 'A','B','E','F' and having temporary promotion step, get from position extra info
3332: IF l_prd IN ('A','B','E','F') AND
3333: ghr_pa_requests_pkg.temp_step_true(p_pa_request_id) THEN
3334: ghr_history_fetch.fetch_positionei(
3335: p_position_id => l_from_position_id,
3336: p_information_type => 'GHR_US_POS_VALID_GRADE',
3337: p_date_effective => nvl(p_effective_date,trunc(sysdate)),

Line 3341: l_from_pay_basis := ghr_pa_requests_pkg.get_upd34_pay_basis

3337: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
3338: p_pos_ei_data => l_pos_ei_grade_data);
3339: l_from_pay_basis := l_pos_ei_grade_data.poei_information6;
3340: ELSE
3341: l_from_pay_basis := ghr_pa_requests_pkg.get_upd34_pay_basis
3342: (p_person_id => p_person_id
3343: ,p_position_id => l_from_position_id
3344: ,p_prd => l_prd
3345: ,p_noa_code => null

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

3409: l_value varchar2(60);
3410: l_multi_error_flag BOOLEAN;
3411: l_gm_unadjd_basic_pay Number;
3412:
3413: CURSOR get_asgn_pos (c_person_id IN ghr_pa_requests.person_id%type,
3414: c_effective_date IN ghr_pa_requests.effective_date%type)
3415: IS
3416: SELECT paf.assignment_id
3417: FROM per_assignments_f paf

Line 3414: c_effective_date IN ghr_pa_requests.effective_date%type)

3410: l_multi_error_flag BOOLEAN;
3411: l_gm_unadjd_basic_pay Number;
3412:
3413: CURSOR get_asgn_pos (c_person_id IN ghr_pa_requests.person_id%type,
3414: c_effective_date IN ghr_pa_requests.effective_date%type)
3415: IS
3416: SELECT paf.assignment_id
3417: FROM per_assignments_f paf
3418: WHERE paf.person_id = c_person_id

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

3586: l_value varchar2(60);
3587: l_multi_error_flag BOOLEAN;
3588: l_gm_unadjd_basic_pay Number;
3589:
3590: CURSOR get_asgn_pos (c_person_id IN ghr_pa_requests.person_id%type,
3591: c_effective_date IN ghr_pa_requests.effective_date%type)
3592: IS
3593: SELECT paf.assignment_id
3594: FROM per_assignments_f paf

Line 3591: c_effective_date IN ghr_pa_requests.effective_date%type)

3587: l_multi_error_flag BOOLEAN;
3588: l_gm_unadjd_basic_pay Number;
3589:
3590: CURSOR get_asgn_pos (c_person_id IN ghr_pa_requests.person_id%type,
3591: c_effective_date IN ghr_pa_requests.effective_date%type)
3592: IS
3593: SELECT paf.assignment_id
3594: FROM per_assignments_f paf
3595: WHERE paf.person_id = c_person_id

Line 4981: ,p_prd IN ghr_pa_requests.pay_rate_determinant%type

4977: ,p_effective_date IN DATE
4978: ,p_basic_pay IN NUMBER
4979: ,p_adj_basic_pay IN NUMBER
4980: ,p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
4981: ,p_prd IN ghr_pa_requests.pay_rate_determinant%type
4982: ,p_pay_basis IN VARCHAR2
4983: ,p_person_id IN per_people_f.person_id%TYPE
4984: ,p_award_amount OUT NOCOPY NUMBER
4985: ,p_award_salary OUT NOCOPY NUMBER

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

5016: WHERE utb.user_table_name = p_user_table_name;
5017:
5018: BEGIN
5019: hr_utility.set_location('Entering ...'|| l_proc,100);
5020: l_psi := ghr_pa_requests_pkg.get_personnel_system_indicator(p_position_id,p_effective_date);
5021:
5022: hr_utility.set_location('personnel system ...'|| l_psi,101);
5023:
5024: IF l_psi <> '00' THEN --for NSPS