DBA Data[Home] [Help]

APPS.PQP_ITERATIVE_ARREARAGE dependencies on HR_ORGANIZATION_INFORMATION

Line 15: from hr_organization_information hoi

11: Cursor csr_org_info (c_business_grp_id In Number
12: ,c_org_information_context In Varchar2) Is
13: select hoi.org_information1
14: ,hoi.org_information2
15: from hr_organization_information hoi
16: where hoi.organization_id = c_business_grp_id
17: and hoi.org_information_context = c_org_information_context;
18:
19: -- ================================================================

Line 51: l_org_information_type hr_organization_information.org_information_context%TYPE;

47: and trunc(c_effective_date) between pet.effective_start_date
48: and pet.effective_end_date;
49:
50: l_ele_information_type pay_element_type_extra_info.information_type%TYPE;
51: l_org_information_type hr_organization_information.org_information_context%TYPE;
52: l_arr_info_rec csr_arr_info%ROWTYPE;
53: l_org_info_rec csr_org_info%ROWTYPE;
54: l_calc_method hr_organization_information.org_information1%TYPE;
55: l_to_with_amt number;

Line 54: l_calc_method hr_organization_information.org_information1%TYPE;

50: l_ele_information_type pay_element_type_extra_info.information_type%TYPE;
51: l_org_information_type hr_organization_information.org_information_context%TYPE;
52: l_arr_info_rec csr_arr_info%ROWTYPE;
53: l_org_info_rec csr_org_info%ROWTYPE;
54: l_calc_method hr_organization_information.org_information1%TYPE;
55: l_to_with_amt number;
56: l_process_name Varchar2(150) := g_pkg_name||'Get_Arrearage_Info';
57: Begin
58: hr_utility.set_location('Entering: '||l_process_name, 5);

Line 513: l_calc_method hr_organization_information.org_information1%TYPE;

509:
510: l_return_value Number := 0;
511: l_arrears_allowed Varchar2(2);
512: l_partial_allowed Varchar2(2);
513: l_calc_method hr_organization_information.org_information1%TYPE;
514: l_to_with_amt number;
515: l_process_name Varchar2(250) := g_pkg_name||'Set_Iteration_Values';
516: Begin
517: