DBA Data[Home] [Help]

APPS.PA_PROJECT_PUB dependencies on PA_IMPLEMENTATIONS

Line 223: FROM pa_implementations;

219: /* added the below cursor for bug 3000981 */
220: CURSOR cur_pa_impl
221: IS
222: SELECT default_rate_type
223: FROM pa_implementations;
224:
225: TYPE override_fields_tbl_type IS TABLE OF l_override_fields_csr%rowtype
226: INDEX BY BINARY_INTEGER;
227:

Line 414: l_cust_acc_rel_code pa_implementations.cust_acc_rel_code%TYPE;

410: l_debug_mode varchar2(1);
411: g_module_name VARCHAR2(100) := 'pa.plsql.CREATE_PROJECT';
412:
413: /* Bug 3077676 */
414: l_cust_acc_rel_code pa_implementations.cust_acc_rel_code%TYPE;
415: CURSOR get_cust_acc_rel_code IS
416: Select cust_acc_rel_code
417: From pa_implementations;
418:

Line 417: From pa_implementations;

413: /* Bug 3077676 */
414: l_cust_acc_rel_code pa_implementations.cust_acc_rel_code%TYPE;
415: CURSOR get_cust_acc_rel_code IS
416: Select cust_acc_rel_code
417: From pa_implementations;
418:
419: -- FP-M Bug # 3301192
420: l_d_task_ver_id NUMBER;
421: l_d_task_id NUMBER;

Line 10471: l_cust_acc_rel_code pa_implementations.cust_acc_rel_code%TYPE;

10467: l_b_cc_tax_task_id VARCHAR2(1) := 'N';
10468: l_cc_tax_task_numb PA_TASKS.TASK_NUMBER%TYPE;
10469:
10470: /* Bug 3077676 */
10471: l_cust_acc_rel_code pa_implementations.cust_acc_rel_code%TYPE;
10472: CURSOR get_cust_acc_rel_code IS
10473: Select cust_acc_rel_code
10474: From pa_implementations;
10475:

Line 10474: From pa_implementations;

10470: /* Bug 3077676 */
10471: l_cust_acc_rel_code pa_implementations.cust_acc_rel_code%TYPE;
10472: CURSOR get_cust_acc_rel_code IS
10473: Select cust_acc_rel_code
10474: From pa_implementations;
10475:
10476: l_deliverable_id NUMBER; -- 3435905
10477: -- 3773373 removed below local variable usage
10478: -- i_dlvr NUMBER := 0; -- 3435905

Line 10854: FROM pa_implementations;

10850:
10851: CURSOR cur_pa_impl
10852: IS
10853: SELECT default_rate_type
10854: FROM pa_implementations;
10855:
10856: l_ALLOW_INV_USER_RATE_FLAG VARCHAR2(1) ;
10857: l_INV_RATE_DATE DATE;
10858: l_INV_RATE_TYPE VARCHAR2 (256) ;