eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_US_NFC_EXTRACTS dependencies on GHR_PA_REQUESTS

Line 30: FROM ghr_pa_requests gpr

26: ,gpr.pa_request_id
27: ,gpr.pa_notification_id
28: ,gpr.first_noa_code
29: ,gpr.second_noa_code
30: FROM ghr_pa_requests gpr
31: WHERE
32: (TRUNC(gpr.effective_date) between c_ext_start_date
33: and c_ext_end_date
34: or

Line 96: FROM ghr_pa_requests gpr

92: ,gpr.pa_request_id
93: ,gpr.pa_notification_id
94: ,gpr.first_noa_code
95: ,gpr.second_noa_code
96: FROM ghr_pa_requests gpr
97: WHERE(TRUNC(gpr.effective_date) between c_ext_start_date
98: and c_ext_end_date
99: or
100: /* TRUNC(gpr.last_update_date) between c_ext_start_date

Line 167: FROM ghr_pa_requests gpr

163:
164: -- Cursor to get the enter record for a given pa_request_id
165: CURSOR csr_rpa_rec(c_pa_request_id in number) is
166: SELECT gpr.*
167: FROM ghr_pa_requests gpr
168: WHERE pa_request_id = c_pa_request_id;
169:
170: -- Cursor to get the extract record id
171: CURSOR csr_ext_rcd(c_hide_flag in varchar2

Line 1138: /*CURSOR c_get_auth_date(c_person_id ghr_pa_requests.person_id%TYPE,

1134: AND cp_effective_date BETWEEN pa.date_from
1135: AND NVL(pa.date_to,TO_DATE('12/31/4712','MM/DD/YYYY'))
1136: AND pa.primary_flag='Y';
1137:
1138: /*CURSOR c_get_auth_date(c_person_id ghr_pa_requests.person_id%TYPE,
1139: c_effective_date ghr_pa_requests.effective_date%TYPE)
1140: IS
1141: SELECT pa_request_id, (effective_date+rownum)-1 auth_date
1142: FROM ghr_pa_requests

Line 1139: c_effective_date ghr_pa_requests.effective_date%TYPE)

1135: AND NVL(pa.date_to,TO_DATE('12/31/4712','MM/DD/YYYY'))
1136: AND pa.primary_flag='Y';
1137:
1138: /*CURSOR c_get_auth_date(c_person_id ghr_pa_requests.person_id%TYPE,
1139: c_effective_date ghr_pa_requests.effective_date%TYPE)
1140: IS
1141: SELECT pa_request_id, (effective_date+rownum)-1 auth_date
1142: FROM ghr_pa_requests
1143: WHERE person_id = c_person_id

Line 1142: FROM ghr_pa_requests

1138: /*CURSOR c_get_auth_date(c_person_id ghr_pa_requests.person_id%TYPE,
1139: c_effective_date ghr_pa_requests.effective_date%TYPE)
1140: IS
1141: SELECT pa_request_id, (effective_date+rownum)-1 auth_date
1142: FROM ghr_pa_requests
1143: WHERE person_id = c_person_id
1144: AND first_noa_code NOT IN ('001','002')
1145: AND pa_notification_id IS NOT NULL
1146: AND effective_date = c_effective_date

Line 1150: CURSOR c_get_auth_date(c_person_id ghr_pa_requests.person_id%TYPE,

1146: AND effective_date = c_effective_date
1147: ORDER BY last_update_date ASC;
1148: */
1149:
1150: CURSOR c_get_auth_date(c_person_id ghr_pa_requests.person_id%TYPE,
1151: c_effective_date ghr_pa_requests.effective_date%TYPE)
1152: IS
1153: SELECT pa_request_id, (effective_date+rownum)-1 auth_date, noa_code
1154: FROM

Line 1151: c_effective_date ghr_pa_requests.effective_date%TYPE)

1147: ORDER BY last_update_date ASC;
1148: */
1149:
1150: CURSOR c_get_auth_date(c_person_id ghr_pa_requests.person_id%TYPE,
1151: c_effective_date ghr_pa_requests.effective_date%TYPE)
1152: IS
1153: SELECT pa_request_id, (effective_date+rownum)-1 auth_date, noa_code
1154: FROM
1155: (

Line 1157: FROM ghr_pa_requests

1153: SELECT pa_request_id, (effective_date+rownum)-1 auth_date, noa_code
1154: FROM
1155: (
1156: SELECT pa_request_id, effective_date, last_update_date,first_noa_code noa_code
1157: FROM ghr_pa_requests
1158: WHERE person_id = c_person_id
1159: AND first_noa_code NOT IN ('001','002')
1160: AND pa_notification_id IS NOT NULL
1161: AND effective_date = c_effective_date

Line 1164: FROM ghr_pa_requests

1160: AND pa_notification_id IS NOT NULL
1161: AND effective_date = c_effective_date
1162: UNION ALL
1163: SELECT pa_request_id, effective_date, last_update_date,second_noa_code noa_code
1164: FROM ghr_pa_requests
1165: WHERE person_id = c_person_id
1166: AND first_noa_code = '317'
1167: AND second_noa_code = '825'
1168: AND pa_notification_id IS NOT NULL

Line 1175: CURSOR c_rpas_on_date(c_person_id ghr_pa_requests.person_id%TYPE,

1171: ) par;
1172:
1173:
1174:
1175: CURSOR c_rpas_on_date(c_person_id ghr_pa_requests.person_id%TYPE,
1176: c_effective_date ghr_pa_requests.effective_date%TYPE)
1177: IS
1178: SELECT COUNT(*) auth_date
1179: FROM

Line 1176: c_effective_date ghr_pa_requests.effective_date%TYPE)

1172:
1173:
1174:
1175: CURSOR c_rpas_on_date(c_person_id ghr_pa_requests.person_id%TYPE,
1176: c_effective_date ghr_pa_requests.effective_date%TYPE)
1177: IS
1178: SELECT COUNT(*) auth_date
1179: FROM
1180: (

Line 1182: FROM ghr_pa_requests

1178: SELECT COUNT(*) auth_date
1179: FROM
1180: (
1181: SELECT pa_request_id, effective_date, last_update_date,first_noa_code noa_code
1182: FROM ghr_pa_requests
1183: WHERE person_id = c_person_id
1184: AND first_noa_code NOT IN ('001','002')
1185: AND pa_notification_id IS NOT NULL
1186: AND effective_date = c_effective_date

Line 1189: FROM ghr_pa_requests

1185: AND pa_notification_id IS NOT NULL
1186: AND effective_date = c_effective_date
1187: UNION ALL
1188: SELECT pa_request_id, effective_date, last_update_date,second_noa_code noa_code
1189: FROM ghr_pa_requests
1190: WHERE person_id = c_person_id
1191: AND first_noa_code = '317'
1192: AND second_noa_code = '825'
1193: AND pa_notification_id IS NOT NULL

Line 1200: l_noa_code ghr_pa_requests.first_noa_code%type;

1196: ) par;
1197:
1198: l_no_rpa_count BOOLEAN;
1199: l_auth_date date;
1200: l_noa_code ghr_pa_requests.first_noa_code%type;
1201:
1202: l_get_addr_info c_get_addr_info%ROWTYPE;
1203:
1204: l_get_extra_info c_get_extra_info%ROWTYPE;

Line 1444: CURSOR c_get_auth_date(c_person_id ghr_pa_requests.person_id%TYPE,

1440: AND pos.position_id = cp_position_id
1441: AND cp_effective_date between pos.effective_start_date and pos.effective_end_date;
1442:
1443: /*
1444: CURSOR c_get_auth_date(c_person_id ghr_pa_requests.person_id%TYPE,
1445: c_effective_date ghr_pa_requests.effective_date%TYPE)
1446: IS
1447: SELECT pa_request_id, (effective_date+rownum)-1 auth_date
1448: FROM ghr_pa_requests

Line 1445: c_effective_date ghr_pa_requests.effective_date%TYPE)

1441: AND cp_effective_date between pos.effective_start_date and pos.effective_end_date;
1442:
1443: /*
1444: CURSOR c_get_auth_date(c_person_id ghr_pa_requests.person_id%TYPE,
1445: c_effective_date ghr_pa_requests.effective_date%TYPE)
1446: IS
1447: SELECT pa_request_id, (effective_date+rownum)-1 auth_date
1448: FROM ghr_pa_requests
1449: WHERE person_id = c_person_id

Line 1448: FROM ghr_pa_requests

1444: CURSOR c_get_auth_date(c_person_id ghr_pa_requests.person_id%TYPE,
1445: c_effective_date ghr_pa_requests.effective_date%TYPE)
1446: IS
1447: SELECT pa_request_id, (effective_date+rownum)-1 auth_date
1448: FROM ghr_pa_requests
1449: WHERE person_id = c_person_id
1450: AND first_noa_code NOT IN ('001','002')
1451: AND pa_notification_id IS NOT NULL
1452: AND effective_date = c_effective_date

Line 1455: CURSOR c_get_auth_date(c_person_id ghr_pa_requests.person_id%TYPE,

1451: AND pa_notification_id IS NOT NULL
1452: AND effective_date = c_effective_date
1453: ORDER BY last_update_date ASC;*/
1454:
1455: CURSOR c_get_auth_date(c_person_id ghr_pa_requests.person_id%TYPE,
1456: c_effective_date ghr_pa_requests.effective_date%TYPE)
1457: IS
1458: SELECT pa_request_id, (effective_date+rownum)-1 auth_date, noa_code
1459: FROM

Line 1456: c_effective_date ghr_pa_requests.effective_date%TYPE)

1452: AND effective_date = c_effective_date
1453: ORDER BY last_update_date ASC;*/
1454:
1455: CURSOR c_get_auth_date(c_person_id ghr_pa_requests.person_id%TYPE,
1456: c_effective_date ghr_pa_requests.effective_date%TYPE)
1457: IS
1458: SELECT pa_request_id, (effective_date+rownum)-1 auth_date, noa_code
1459: FROM
1460: (

Line 1462: FROM ghr_pa_requests

1458: SELECT pa_request_id, (effective_date+rownum)-1 auth_date, noa_code
1459: FROM
1460: (
1461: SELECT pa_request_id, effective_date, last_update_date,first_noa_code noa_code
1462: FROM ghr_pa_requests
1463: WHERE person_id = c_person_id
1464: AND first_noa_code NOT IN ('001','002')
1465: AND pa_notification_id IS NOT NULL
1466: AND effective_date = c_effective_date

Line 1469: FROM ghr_pa_requests

1465: AND pa_notification_id IS NOT NULL
1466: AND effective_date = c_effective_date
1467: UNION ALL
1468: SELECT pa_request_id, effective_date, last_update_date,second_noa_code noa_code
1469: FROM ghr_pa_requests
1470: WHERE person_id = c_person_id
1471: AND first_noa_code = '317'
1472: AND second_noa_code = '825'
1473: AND pa_notification_id IS NOT NULL

Line 1478: CURSOR c_rpas_on_date(c_person_id ghr_pa_requests.person_id%TYPE,

1474: AND effective_date = c_effective_date
1475: ORDER BY last_update_date
1476: ) par;
1477:
1478: CURSOR c_rpas_on_date(c_person_id ghr_pa_requests.person_id%TYPE,
1479: c_effective_date ghr_pa_requests.effective_date%TYPE)
1480: IS
1481: SELECT COUNT(*) auth_date
1482: FROM

Line 1479: c_effective_date ghr_pa_requests.effective_date%TYPE)

1475: ORDER BY last_update_date
1476: ) par;
1477:
1478: CURSOR c_rpas_on_date(c_person_id ghr_pa_requests.person_id%TYPE,
1479: c_effective_date ghr_pa_requests.effective_date%TYPE)
1480: IS
1481: SELECT COUNT(*) auth_date
1482: FROM
1483: (

Line 1485: FROM ghr_pa_requests

1481: SELECT COUNT(*) auth_date
1482: FROM
1483: (
1484: SELECT pa_request_id, effective_date, last_update_date,first_noa_code noa_code
1485: FROM ghr_pa_requests
1486: WHERE person_id = c_person_id
1487: AND first_noa_code NOT IN ('001','002')
1488: AND pa_notification_id IS NOT NULL
1489: AND effective_date = c_effective_date

Line 1492: FROM ghr_pa_requests

1488: AND pa_notification_id IS NOT NULL
1489: AND effective_date = c_effective_date
1490: UNION ALL
1491: SELECT pa_request_id, effective_date, last_update_date,second_noa_code noa_code
1492: FROM ghr_pa_requests
1493: WHERE person_id = c_person_id
1494: AND first_noa_code = '317'
1495: AND second_noa_code = '825'
1496: AND pa_notification_id IS NOT NULL