APPS.PAY_PYSG8SAD_XMLP_PKG dependencies on HR_ORGANIZATION_INFORMATION

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

30:
31: function CF_legislation_codeFormula return VARCHAR2 is
32: v_cpf_cap varchar2(10);
33: v_sys_date varchar2(11);
34: v_legislation_code hr_organization_information.org_information9%type := null;
35:
36: cursor cpf_cap_method
37: (c_legal_entity_id hr_organization_information.organization_id%type) is
38: select org_information7

Line 37: (c_legal_entity_id hr_organization_information.organization_id%type) is

33: v_sys_date varchar2(11);
34: v_legislation_code hr_organization_information.org_information9%type := null;
35:
36: cursor cpf_cap_method
37: (c_legal_entity_id hr_organization_information.organization_id%type) is
38: select org_information7
39: from hr_organization_information
40: where org_information_context = 'SG_LEGAL_ENTITY'
41: and organization_id = c_legal_entity_id;

Line 39: from hr_organization_information

35:
36: cursor cpf_cap_method
37: (c_legal_entity_id hr_organization_information.organization_id%type) is
38: select org_information7
39: from hr_organization_information
40: where org_information_context = 'SG_LEGAL_ENTITY'
41: and organization_id = c_legal_entity_id;
42:
43: cursor legislation_code

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

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

Line 46: from hr_organization_information

42:
43: cursor legislation_code
44: (c_business_group_id hr_organization_information.organization_id%type) is
45: select org_information9
46: from hr_organization_information
47: where organization_id = c_business_group_id
48: and org_information9 is not null;
49:
50: