DBA Data[Home] [Help]

APPS.IGC_CC_APPROVAL_WF_PKG dependencies on HR_ORGANIZATION_UNITS

Line 1843: l_org_name hr_organization_units.name%TYPE;

1839: l_cc_desc igc_cc_headers.cc_desc%TYPE;
1840: l_cc_start_date igc_cc_headers.cc_start_date%TYPE;
1841: l_cc_end_date igc_cc_headers.cc_end_date%TYPE;
1842: l_note VARCHAR2(255);
1843: l_org_name hr_organization_units.name%TYPE;
1844: l_account_date igc_cc_headers.cc_acct_date%TYPE;
1845: l_user_display_name VARCHAR2(255);
1846: l_owner_display_name VARCHAR2(255);
1847: l_use_pos VARCHAR2(1);

Line 1851: FROM hr_organization_units

1847: l_use_pos VARCHAR2(1);
1848:
1849: CURSOR c_org_name IS
1850: SELECT name
1851: FROM hr_organization_units
1852: WHERE organization_id = g_org_id;
1853:
1854: CURSOR c_cc_data IS
1855: SELECT org_id ,