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 1704: ,p_noa_code IN ghr_nature_of_actions.code%TYPE

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

Line 1705: ,p_second_noa_code IN ghr_nature_of_actions.code%TYPE

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

Line 1759: l_noa_code ghr_nature_of_actions.code%TYPE;

1755: l_effective_date DATE;
1756: --
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);

Line 1760: l_second_noa_code ghr_nature_of_actions.code%TYPE;

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

Line 1821: l_retro_first_noa ghr_nature_of_actions.code%type;

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

Line 1822: l_retro_second_noa ghr_nature_of_actions.code%type;

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

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

Line 1827: l_ia_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;
1830: l_value VARCHAR2(60);
1831: l_multi_error_flag BOOLEAN;