APPS.PAY_PAYRPBLK1_XMLP_PKG dependencies on HR_ORGANIZATION_INFORMATION

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

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

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

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

Line 42: from hr_organization_information

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