APPS.GHR_BEN_VALIDATION dependencies on GHR_PA_REQUESTS

Line 39: l_noa_family_code ghr_pa_requests.noa_family_code%type;

35: , p_tsp_roth_401k_amt in number default null
36: , p_tsp_roth_401k_rate in number default null)
37: IS
38: l_payroll_id ghr_pa_request_extra_info.rei_information3%type;
39: l_noa_family_code ghr_pa_requests.noa_family_code%type;
40: l_st_month VARCHAR2(20);
41: l_end_month VARCHAR2(20);
42: l_pay_month VARCHAR2(20);
43: l_start_date per_time_periods.start_date%type;

Line 46: CURSOR c_payroll_id(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS

42: l_pay_month VARCHAR2(20);
43: l_start_date per_time_periods.start_date%type;
44: l_validate BOOLEAN;
45:
46: CURSOR c_payroll_id(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
47: SELECT rei_information3 payroll_id
48: FROM ghr_pa_request_extra_info
49: WHERE pa_request_id = c_pa_request_id
50: AND information_type = 'GHR_US_PAR_PAYROLL_TYPE';

Line 73: FROM ghr_pa_requests

69:
70: --Begin Bug 12637350
71: CURSOR c_first_nte_date is
72: SELECT first_noa_information1
73: FROM ghr_pa_requests
74: WHERE pa_request_id = p_pa_request_id;
75:
76: l_nte_date ghr_pa_requests.first_noa_information1%type;
77:

Line 76: l_nte_date ghr_pa_requests.first_noa_information1%type;

72: SELECT first_noa_information1
73: FROM ghr_pa_requests
74: WHERE pa_request_id = p_pa_request_id;
75:
76: l_nte_date ghr_pa_requests.first_noa_information1%type;
77:
78: cursor cur_asg_prior_date( p_assignment_id in number) is
79: Select asg.effective_start_date
80: from per_all_assignments_f asg

Line 838: l_retirement_plan ghr_pa_requests.retirement_plan%type;

834: l_person_id per_all_people_f.person_id%type;
835: l_new_element_name pay_element_types_f.element_name%type;
836: l_element_name pay_element_types_f.element_name%type;
837: l_ret_plan_name varchar2(200);
838: l_retirement_plan ghr_pa_requests.retirement_plan%type;
839: l_debug_mode BOOLEAN;
840:
841: --12973371 Added TSP Roth Amount and Rate
842: l_roth_amount number;