APPS.PAY_PYNZQES_XMLP_PKG dependencies on HR_ORGANIZATION_INFORMATION

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

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

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

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

Line 43: from hr_organization_information

39: cursor legislation_code
40: (c_business_group_id hr_organization_information.organization_id%type) is
41:
42: select org_information9
43: from hr_organization_information
44: where organization_id = c_business_group_id
45: and org_information9 is not null;
46: begin
47: open legislation_code (p_business_group_id);