APPS.PAY_PAYKRSOE_XMLP_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 44: v_legislation_code hr_organization_information.org_information9%type := null;

40: end;
41:
42: function CF_legislation_codeFormula return VARCHAR2 is
43:
44: v_legislation_code hr_organization_information.org_information9%type := null;
45:
46: cursor legislation_code
47: (c_business_group_id hr_organization_information.organization_id%type) is
48:

Line 47: (c_business_group_id hr_organization_information.organization_id%type) is

43:
44: v_legislation_code hr_organization_information.org_information9%type := null;
45:
46: cursor legislation_code
47: (c_business_group_id hr_organization_information.organization_id%type) is
48:
49: select org_information9
50: from hr_organization_information
51: where organization_id = c_business_group_id

Line 50: from hr_organization_information

46: cursor legislation_code
47: (c_business_group_id hr_organization_information.organization_id%type) is
48:
49: select org_information9
50: from hr_organization_information
51: where organization_id = c_business_group_id
52: and org_information9 is not null
53: and org_information_context = 'Business Group Information';
54: begin

Line 244: lv_Bus_Place hr_organization_information.Org_Information1%TYPE;

240:
241: lv_Effective_Date Pay_Payroll_Actions.Effective_Date%TYPE;
242: lv_Payroll_Name Pay_PAyrolls_F.Payroll_Name%TYPE;
243: lv_RunType_Period VARCHAR2(100);
244: lv_Bus_Place hr_organization_information.Org_Information1%TYPE;
245: lv_Assignment_Number Per_Assignments_F.Assignment_Number%TYPE;
246: lvnum NUMBER;
247: lvmesg VARCHAR2(2000);
248: lvsort1 VARCHAR2(50);

Line 313: From hr_organization_information

309:
310: Begin
311: Select Org_Information1
312: Into lv_Bus_Place
313: From hr_organization_information
314: Where org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
315: And Organization_Id = P_ESTABLISHMENT_ID;
316:
317: CP_Bus_Place := lv_Bus_Place;