DBA Data[Home] [Help]

APPS.PAY_FR_DADS_ESTAB_COMP dependencies on HR_ORGANIZATION_INFORMATION

Line 6: (cre_estab_id hr_organization_information.organization_id%TYPE,

2: /* $Header: pyfrdesc.pkh 115.3 2003/12/10 02:39:54 abhaduri noship $ */
3: --
4: --
5: TYPE cre_info_issue_rec is RECORD
6: (cre_estab_id hr_organization_information.organization_id%TYPE,
7: cre_name hr_all_organization_units_tl.name%TYPE,
8: cre_siren hr_organization_information.org_information1%TYPE,
9: cre_nic varchar2(7),
10: cre_media hr_organization_information.org_information1%TYPE ,

Line 8: cre_siren hr_organization_information.org_information1%TYPE,

4: --
5: TYPE cre_info_issue_rec is RECORD
6: (cre_estab_id hr_organization_information.organization_id%TYPE,
7: cre_name hr_all_organization_units_tl.name%TYPE,
8: cre_siren hr_organization_information.org_information1%TYPE,
9: cre_nic varchar2(7),
10: cre_media hr_organization_information.org_information1%TYPE ,
11: address_to_use hr_organization_information.org_information2%TYPE);
12: --

Line 10: cre_media hr_organization_information.org_information1%TYPE ,

6: (cre_estab_id hr_organization_information.organization_id%TYPE,
7: cre_name hr_all_organization_units_tl.name%TYPE,
8: cre_siren hr_organization_information.org_information1%TYPE,
9: cre_nic varchar2(7),
10: cre_media hr_organization_information.org_information1%TYPE ,
11: address_to_use hr_organization_information.org_information2%TYPE);
12: --
13: g_cre_info_issue cre_info_issue_rec;
14: --

Line 11: address_to_use hr_organization_information.org_information2%TYPE);

7: cre_name hr_all_organization_units_tl.name%TYPE,
8: cre_siren hr_organization_information.org_information1%TYPE,
9: cre_nic varchar2(7),
10: cre_media hr_organization_information.org_information1%TYPE ,
11: address_to_use hr_organization_information.org_information2%TYPE);
12: --
13: g_cre_info_issue cre_info_issue_rec;
14: --
15: PROCEDURE S10_00_issue_estab(p_param_reference IN VARCHAR2,