DBA Data[Home] [Help]

APPS.GHR_PAY_CALC dependencies on GHR_NATURE_OF_ACTIONS

Line 166: l_first_noa_code ghr_nature_of_actions.code%TYPE;

162: ,p_pay_plan IN VARCHAR2
163: ,p_prd IN VARCHAR2
164: ,p_pa_request_id IN NUMBER)
165: RETURN BOOLEAN IS
166: l_first_noa_code ghr_nature_of_actions.code%TYPE;
167: l_second_noa_code ghr_nature_of_actions.code%TYPE;
168: l_pay_plan VARCHAR2(30);
169: l_prd VARCHAR2(30);
170: --

Line 167: l_second_noa_code ghr_nature_of_actions.code%TYPE;

163: ,p_prd IN VARCHAR2
164: ,p_pa_request_id IN NUMBER)
165: RETURN BOOLEAN IS
166: l_first_noa_code ghr_nature_of_actions.code%TYPE;
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;

Line 222: ,p_noa_code IN ghr_nature_of_actions.code%TYPE

218: FUNCTION populate_in_rec_structure
219: (p_person_id IN per_people_f.person_id%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

Line 223: ,p_second_noa_code IN ghr_nature_of_actions.code%TYPE

219: (p_person_id IN per_people_f.person_id%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

Line 1650: ,p_noa_code IN ghr_nature_of_actions.code%TYPE

1646:
1647: PROCEDURE main_pay_calc (p_person_id IN per_people_f.person_id%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

Line 1651: ,p_second_noa_code IN ghr_nature_of_actions.code%TYPE

1647: PROCEDURE main_pay_calc (p_person_id IN per_people_f.person_id%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

Line 1705: l_noa_code ghr_nature_of_actions.code%TYPE;

1701: l_effective_date DATE;
1702: --
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);

Line 1706: l_second_noa_code ghr_nature_of_actions.code%TYPE;

1702: --
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);

Line 1767: l_retro_first_noa ghr_nature_of_actions.code%type;

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;
1771: l_ia_effective_date ghr_pa_requests.effective_date%type;

Line 1768: l_retro_second_noa ghr_nature_of_actions.code%type;

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;
1771: l_ia_effective_date ghr_pa_requests.effective_date%type;
1772: l_ia_retro_first_noa ghr_nature_of_actions.code%type;

Line 1772: l_ia_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;
1776: l_value VARCHAR2(60);

Line 1773: l_ia_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;
1776: l_value VARCHAR2(60);
1777: l_multi_error_flag BOOLEAN;