APPS.PAY_NL_NSI_PROCESS dependencies on FND_TERRITORIES_VL

Line 115: |Description : Function to get the country name from FND_TERRITORIES_VL |

111:
112: /*-------------------------------------------------------------------------------
113: |Name : get_country_name |
114: |Type : Function |
115: |Description : Function to get the country name from FND_TERRITORIES_VL |
116: -------------------------------------------------------------------------------*/
117:
118: FUNCTION get_country_name(p_territory_code VARCHAR2) RETURN VARCHAR2 IS
119: CURSOR csr_get_territory_name(p_territory_code VARCHAR2) Is

Line 121: FROM FND_TERRITORIES_VL

117:
118: FUNCTION get_country_name(p_territory_code VARCHAR2) RETURN VARCHAR2 IS
119: CURSOR csr_get_territory_name(p_territory_code VARCHAR2) Is
120: SELECT TERRITORY_SHORT_NAME
121: FROM FND_TERRITORIES_VL
122: WHERE TERRITORY_CODE = p_territory_code;
123:
124: l_country FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;
125: BEGIN

Line 124: l_country FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;

120: SELECT TERRITORY_SHORT_NAME
121: FROM FND_TERRITORIES_VL
122: WHERE TERRITORY_CODE = p_territory_code;
123:
124: l_country FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;
125: BEGIN
126: OPEN csr_get_territory_name(p_territory_code);
127: FETCH csr_get_territory_name into l_country;
128: CLOSE csr_get_territory_name;

Line 874: l_Country_Name FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;

870: l_St_Date_Lab_Rel VARCHAR2(8);
871: l_SOFI_Number VARCHAR2(9);
872: l_Employee_Name VARCHAR2(150);
873: l_Employee_Primary_Add VARCHAR2(150);
874: l_Country_Name FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;
875: l_Employee_Pop_Reg_Add VARCHAR2(150);
876: l_Gak_Rep_Info VARCHAR2(150);
877: l_Cadans_Rep_Info VARCHAR2(150);
878: l_Employee_Details VARCHAR2(150);