APPS.PAY_PAYKRSPL_XMLP_PKG dependencies on HR_ORGANIZATION_INFORMATION

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

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

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

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

Line 44: from hr_organization_information

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