APPS.AP_WEB_UPLOAD_PDM_PKG dependencies on AP_POL_HEADERS

Line 752: select AP_POL_HEADERS_S.NEXTVAL

748: l_policy_id NUMBER(15);
749:
750: BEGIN
751:
752: select AP_POL_HEADERS_S.NEXTVAL
753: into l_policy_id
754: from dual;
755:
756: insert into AP_POL_HEADERS

Line 756: insert into AP_POL_HEADERS

752: select AP_POL_HEADERS_S.NEXTVAL
753: into l_policy_id
754: from dual;
755:
756: insert into AP_POL_HEADERS
757: (
758: POLICY_ID,
759: CATEGORY_CODE,
760: SCHEDULE_TYPE_CODE,

Line 1254: from ap_pol_headers

1250: ------------------------------------------------------------------------
1251:
1252: cursor policy_cur is
1253: select policy_id
1254: from ap_pol_headers
1255: where policy_id = p_policy_id
1256: and rownum = 1;
1257:
1258: policy_rec policy_cur%ROWTYPE;

Line 1374: from ap_pol_headers

1370: ------------------------------------------------------------------------
1371:
1372: CURSOR policy_cur IS
1373: select policy_id
1374: from ap_pol_headers
1375: where category_code = p_expense_category
1376: and upper(policy_name) = upper(p_policy_name)
1377: and rownum = 1;
1378:

Line 1474: from ap_pol_headers

1470: ------------------------------------------------------------------------
1471:
1472: CURSOR per_diem_type_code_cur IS
1473: select per_diem_type_code
1474: from ap_pol_headers
1475: where policy_id = p_policy_id
1476: and rownum = 1;
1477:
1478: per_diem_type_code_rec per_diem_type_code_cur%ROWTYPE;

Line 1501: from ap_pol_headers

1497: ------------------------------------------------------------------------
1498:
1499: CURSOR meals_type_code_cur IS
1500: select meals_type_code
1501: from ap_pol_headers
1502: where policy_id = p_policy_id
1503: and rownum = 1;
1504:
1505: meals_type_code_rec meals_type_code_cur%ROWTYPE;