APPS.PAY_PYNZREC_XMLP_PKG dependencies on HR_ORGANIZATION_INFORMATION

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

68: end;
69:
70: function CF_legislation_codeFormula return VARCHAR2 is
71:
72: v_legislation_code hr_organization_information.org_information9%type := null;
73:
74: cursor legislation_code
75: (c_business_group_id hr_organization_information.organization_id%type) is
76:

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

71:
72: v_legislation_code hr_organization_information.org_information9%type := null;
73:
74: cursor legislation_code
75: (c_business_group_id hr_organization_information.organization_id%type) is
76:
77: select org_information9
78: from hr_organization_information
79: where organization_id = c_business_group_id

Line 78: from hr_organization_information

74: cursor legislation_code
75: (c_business_group_id hr_organization_information.organization_id%type) is
76:
77: select org_information9
78: from hr_organization_information
79: where organization_id = c_business_group_id
80: and org_information9 is not null;
81: begin
82: open legislation_code (p_business_group_id);