DBA Data[Home] [Help]

APPS.JTF_RS_GROUP_ORGS_PVT dependencies on JTF_RS_GROUPS_B

Line 66: CURSOR c_validate_group(ll_group_id IN JTF_RS_GROUPS_B.GROUP_ID%TYPE) IS

62: l_org_end_date DATE;
63: l_org_name hr_all_organization_units_tl.NAME%TYPE;
64: l_mapping_exist VARCHAR2(30);
65:
66: CURSOR c_validate_group(ll_group_id IN JTF_RS_GROUPS_B.GROUP_ID%TYPE) IS
67: SELECT start_date_active,
68: NVL(end_date_active, TRUNC(SYSDATE)+1),
69: group_name
70: FROM jtf_rs_groups_vl