APPS.JA_CN_COA_EXP_PKG dependencies on PER_ALL_PEOPLE_F

Line 1945: -- and personnel name from table PER_ALL_PEOPLE_F

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

Line 1953: ,PER_ALL_PEOPLE_F PER

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