APPS.JA_CN_COA_EXP_PKG dependencies on PER_ALL_PEOPLE_F

Line 1943: -- and personnel name from table PER_ALL_PEOPLE_F

1939: l_person_number JA_CN_ACCOUNT_BALANCES.personnel_number%TYPE;
1940: l_person_name VARCHAR2(50);
1941:
1942: --Cursor to get personnel_number from table JA_CN_ACCOUNT_BALANCES,
1943: -- and personnel name from table PER_ALL_PEOPLE_F
1944: CURSOR c_person IS
1945: SELECT *
1946: FROM (
1947: SELECT DISTINCT

Line 1951: ,PER_ALL_PEOPLE_F PER

1947: SELECT DISTINCT
1948: BAL.personnel_number person_number
1949: ,nvl(PER.last_name||PER.first_name, '') person_name
1950: FROM JA_CN_ACCOUNT_BALANCES BAL
1951: ,PER_ALL_PEOPLE_F PER
1952: WHERE BAL.Ledger_Id = l_ledger_id --using variable l_ledger_id
1953: AND BAL.account_segment IS NOT NULL
1954: and BAL.personnel_id IS NOT NULL
1955: AND PER.person_id = BAL.personnel_id