APPS.PAY_NL_PAYSLIP_ARCHIVE dependencies on FND_TERRITORIES_VL

Line 1565: FROM FND_TERRITORIES_VL

1561: --
1562:
1563: /*CURSOR csr_get_territory_name(p_territory_code VARCHAR2) Is
1564: SELECT TERRITORY_SHORT_NAME
1565: FROM FND_TERRITORIES_VL
1566: WHERE TERRITORY_CODE = p_territory_code;*/
1567: --
1568: --
1569: CURSOR csr_get_regular_working_hrs(p_assignment_id NUMBER) IS

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

2092: END ARCHIVE_NL_EMPLOYEE_DETAILS;
2093: /*-------------------------------------------------------------------------------
2094: |Name : get_country_name |
2095: |Type : Function |
2096: |Description : Function to get the country name from FND_TERRITORIES_VL |
2097: -------------------------------------------------------------------------------*/
2098:
2099: FUNCTION get_country_name(p_territory_code VARCHAR2) RETURN VARCHAR2 IS
2100: CURSOR csr_get_territory_name(p_territory_code VARCHAR2) Is

Line 2102: FROM FND_TERRITORIES_VL

2098:
2099: FUNCTION get_country_name(p_territory_code VARCHAR2) RETURN VARCHAR2 IS
2100: CURSOR csr_get_territory_name(p_territory_code VARCHAR2) Is
2101: SELECT TERRITORY_SHORT_NAME
2102: FROM FND_TERRITORIES_VL
2103: WHERE TERRITORY_CODE = p_territory_code;
2104:
2105: l_country FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;
2106: BEGIN

Line 2105: l_country FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;

2101: SELECT TERRITORY_SHORT_NAME
2102: FROM FND_TERRITORIES_VL
2103: WHERE TERRITORY_CODE = p_territory_code;
2104:
2105: l_country FND_TERRITORIES_VL.TERRITORY_SHORT_NAME%TYPE;
2106: BEGIN
2107: OPEN csr_get_territory_name(p_territory_code);
2108: FETCH csr_get_territory_name into l_country;
2109: CLOSE csr_get_territory_name;