APPS.PAY_PAYSG21A_XMLP_PKG dependencies on HR_ORGANIZATION_INFORMATION

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

48: end;
49:
50: function CF_legislation_codeFormula return VARCHAR2 is
51:
52: v_legislation_code hr_organization_information.org_information9%type := null;
53:
54: cursor legislation_code
55: (c_business_group_id hr_organization_information.organization_id%type) is
56:

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

51:
52: v_legislation_code hr_organization_information.org_information9%type := null;
53:
54: cursor legislation_code
55: (c_business_group_id hr_organization_information.organization_id%type) is
56:
57: select org_information9
58: from hr_organization_information
59: where organization_id = c_business_group_id

Line 58: from hr_organization_information

54: cursor legislation_code
55: (c_business_group_id hr_organization_information.organization_id%type) is
56:
57: select org_information9
58: from hr_organization_information
59: where organization_id = c_business_group_id
60: and org_information9 is not null
61: and org_information_context = 'Business Group Information';
62: begin