APPS.PAY_PAYCNSOE_XMLP_PKG dependencies on HR_ORGANIZATION_INFORMATION

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

31: end;
32:
33: function CF_legislation_codeFormula return VARCHAR2 is
34:
35: v_legislation_code hr_organization_information.org_information9%type := null;
36:
37: cursor legislation_code
38: (c_business_group_id hr_organization_information.organization_id%type) is
39:

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

34:
35: v_legislation_code hr_organization_information.org_information9%type := null;
36:
37: cursor legislation_code
38: (c_business_group_id hr_organization_information.organization_id%type) is
39:
40: select org_information9
41: from hr_organization_information
42: where organization_id = c_business_group_id

Line 41: from hr_organization_information

37: cursor legislation_code
38: (c_business_group_id hr_organization_information.organization_id%type) is
39:
40: select org_information9
41: from hr_organization_information
42: where organization_id = c_business_group_id
43: and org_information9 is not null
44: and org_information_context = 'Business Group Information';
45: begin