DBA Data[Home] [Help]

APPS.PON_EMD_AR_INTEGRATION_GRP dependencies on HR_OPERATING_UNITS

Line 826: l_organization_name hr_operating_units.NAME%TYPE;

822: l_party_site_id hz_party_sites.party_site_id%TYPE DEFAULT NULL;
823: l_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL;
824: x_msg_count NUMBER;
825: x_msg_data VARCHAR2(1000);
826: l_organization_name hr_operating_units.NAME%TYPE;
827:
828: BEGIN
829:
830: l_progress := 100;

Line 857: FROM hr_operating_units

853: l_org_id := p_in_rec.org_id;
854: BEGIN
855: SELECT name
856: INTO l_organization_name
857: FROM hr_operating_units
858: WHERE organization_id = l_org_id;
859: EXCEPTION
860: WHEN OTHERS THEN
861: x_return_status := fnd_api.g_ret_sts_error;

Line 4620: l_organization_name hr_operating_units.NAME%TYPE;

4616:
4617: l_term_name ra_terms_vl.NAME%TYPE;
4618: l_term_start_date ra_terms_vl.START_DATE_ACTIVE%TYPE;
4619: l_term_end_Date ra_terms_vl.END_DATE_ACTIVE%TYPE;
4620: l_organization_name hr_operating_units.NAME%TYPE;
4621: l_ra_batch_source_id NUMBER(15);
4622:
4623: BEGIN
4624: x_return_status := fnd_api.g_ret_sts_success;

Line 4629: FROM hr_operating_units

4625:
4626: BEGIN
4627: SELECT name
4628: INTO l_organization_name
4629: FROM hr_operating_units
4630: WHERE organization_id = p_org_id;
4631: EXCEPTION
4632: WHEN OTHERS THEN
4633: x_return_status := fnd_api.g_ret_sts_error;