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.PA_CREATE_RESOURCE dependencies on PA_RESOURCE_TXN_ATTRIBUTES

Line 27: l_person_id pa_resource_txn_attributes.person_id%TYPE;

23: l_resource_type_id NUMBER := 0;
24: l_org_id NUMBER := NULL;
25:
26: /*bug 1889671 : Resource Mapping Enhancement -- Code changes starts */
27: l_person_id pa_resource_txn_attributes.person_id%TYPE;
28: l_job_id pa_resource_txn_attributes.job_id%TYPE;
29: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
30: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
31: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;

Line 28: l_job_id pa_resource_txn_attributes.job_id%TYPE;

24: l_org_id NUMBER := NULL;
25:
26: /*bug 1889671 : Resource Mapping Enhancement -- Code changes starts */
27: l_person_id pa_resource_txn_attributes.person_id%TYPE;
28: l_job_id pa_resource_txn_attributes.job_id%TYPE;
29: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
30: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
31: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
32: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;

Line 29: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;

25:
26: /*bug 1889671 : Resource Mapping Enhancement -- Code changes starts */
27: l_person_id pa_resource_txn_attributes.person_id%TYPE;
28: l_job_id pa_resource_txn_attributes.job_id%TYPE;
29: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
30: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
31: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
32: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
33: l_event_type pa_resource_txn_attributes.event_type%TYPE;

Line 30: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;

26: /*bug 1889671 : Resource Mapping Enhancement -- Code changes starts */
27: l_person_id pa_resource_txn_attributes.person_id%TYPE;
28: l_job_id pa_resource_txn_attributes.job_id%TYPE;
29: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
30: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
31: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
32: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
33: l_event_type pa_resource_txn_attributes.event_type%TYPE;
34: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;

Line 31: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;

27: l_person_id pa_resource_txn_attributes.person_id%TYPE;
28: l_job_id pa_resource_txn_attributes.job_id%TYPE;
29: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
30: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
31: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
32: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
33: l_event_type pa_resource_txn_attributes.event_type%TYPE;
34: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
35: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;

Line 32: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;

28: l_job_id pa_resource_txn_attributes.job_id%TYPE;
29: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
30: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
31: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
32: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
33: l_event_type pa_resource_txn_attributes.event_type%TYPE;
34: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
35: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
36: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;

Line 33: l_event_type pa_resource_txn_attributes.event_type%TYPE;

29: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
30: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
31: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
32: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
33: l_event_type pa_resource_txn_attributes.event_type%TYPE;
34: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
35: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
36: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;
37: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;

Line 34: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;

30: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
31: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
32: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
33: l_event_type pa_resource_txn_attributes.event_type%TYPE;
34: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
35: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
36: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;
37: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;
38: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;

Line 35: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;

31: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
32: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
33: l_event_type pa_resource_txn_attributes.event_type%TYPE;
34: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
35: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
36: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;
37: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;
38: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;
39: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;

Line 36: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;

32: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
33: l_event_type pa_resource_txn_attributes.event_type%TYPE;
34: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
35: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
36: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;
37: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;
38: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;
39: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;
40: l_resource_format_id pa_resource_txn_attributes.resource_format_id%TYPE;

Line 37: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;

33: l_event_type pa_resource_txn_attributes.event_type%TYPE;
34: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
35: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
36: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;
37: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;
38: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;
39: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;
40: l_resource_format_id pa_resource_txn_attributes.resource_format_id%TYPE;
41: l_res_type_code pa_resource_types.resource_type_code%TYPE;

Line 38: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;

34: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
35: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
36: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;
37: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;
38: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;
39: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;
40: l_resource_format_id pa_resource_txn_attributes.resource_format_id%TYPE;
41: l_res_type_code pa_resource_types.resource_type_code%TYPE;
42:

Line 39: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;

35: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
36: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;
37: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;
38: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;
39: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;
40: l_resource_format_id pa_resource_txn_attributes.resource_format_id%TYPE;
41: l_res_type_code pa_resource_types.resource_type_code%TYPE;
42:
43: CURSOR Cur_TXn_Attributes(p_resource_id PA_RESOURCES.RESOURCE_ID%TYPE) IS

Line 40: l_resource_format_id pa_resource_txn_attributes.resource_format_id%TYPE;

36: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;
37: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;
38: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;
39: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;
40: l_resource_format_id pa_resource_txn_attributes.resource_format_id%TYPE;
41: l_res_type_code pa_resource_types.resource_type_code%TYPE;
42:
43: CURSOR Cur_TXn_Attributes(p_resource_id PA_RESOURCES.RESOURCE_ID%TYPE) IS
44: SELECT prta.person_id,

Line 60: FROM PA_RESOURCE_TXN_ATTRIBUTES PRTA,

56: prta.system_linkage_function,
57: prta.resource_format_id,
58: prt.resource_type_id,
59: prt.resource_type_code
60: FROM PA_RESOURCE_TXN_ATTRIBUTES PRTA,
61: PA_RESOURCES PR,
62: PA_RESOURCE_TYPES PRT
63: WHERE prta.resource_id = pr.resource_id
64: AND pr.resource_id =P_RESOURCE_ID

Line 1390: --Description: This procedure inserts rows into pa_resource_txn_attributes...

1386:
1387: END chk_plan_rl_unique;
1388: --Name: Create_Resource_txn_Attribute
1389: --Type: Procedure
1390: --Description: This procedure inserts rows into pa_resource_txn_attributes...
1391: --
1392: --Called subprograms: ?
1393: --
1394: --History:

Line 1482: SELECT pa_resource_txn_attributes_s.NEXTVAL

1478:
1479: /* Bug # 932398 Fix : Added flags for non-labor resources in the above cursor */
1480:
1481: CURSOR c_res_txn_attr_seq_csr IS
1482: SELECT pa_resource_txn_attributes_s.NEXTVAL
1483: FROM SYS.DUAL;
1484:
1485: BEGIN
1486: l_old_stack := p_err_stack;

Line 1561: p_err_stage := 'Select pa_resource_txn_attributes_s.nextval from sys.dual ';

1557: ELSE
1558: CLOSE c_res_format_csr;
1559: END IF;
1560:
1561: p_err_stage := 'Select pa_resource_txn_attributes_s.nextval from sys.dual ';
1562:
1563: OPEN c_res_txn_attr_seq_csr;
1564: FETCH c_res_txn_attr_seq_csr INTO
1565: l_resource_txn_attribute_id;

Line 1573: p_err_stage := 'Insert into pa_resource_txn_attributes ';

1569: ELSE
1570: CLOSE c_res_txn_attr_seq_csr;
1571: END IF;
1572:
1573: p_err_stage := 'Insert into pa_resource_txn_attributes ';
1574:
1575: INSERT INTO pa_resource_txn_attributes
1576: (
1577: resource_txn_attribute_id,

Line 1575: INSERT INTO pa_resource_txn_attributes

1571: END IF;
1572:
1573: p_err_stage := 'Insert into pa_resource_txn_attributes ';
1574:
1575: INSERT INTO pa_resource_txn_attributes
1576: (
1577: resource_txn_attribute_id,
1578: resource_id ,
1579: person_id,

Line 2503: l_person_id pa_resource_txn_attributes.person_id%TYPE;

2499: l_alias VARCHAR2(30);
2500: l_new_track_as_labor_flag VARCHAR2(1);
2501: l_org_id NUMBER := NULL;
2502: l_resource_type_id pa_resource_types.resource_type_id%TYPE;
2503: l_person_id pa_resource_txn_attributes.person_id%TYPE;
2504: l_job_id pa_resource_txn_attributes.job_id%TYPE;
2505: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
2506: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
2507: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;

Line 2504: l_job_id pa_resource_txn_attributes.job_id%TYPE;

2500: l_new_track_as_labor_flag VARCHAR2(1);
2501: l_org_id NUMBER := NULL;
2502: l_resource_type_id pa_resource_types.resource_type_id%TYPE;
2503: l_person_id pa_resource_txn_attributes.person_id%TYPE;
2504: l_job_id pa_resource_txn_attributes.job_id%TYPE;
2505: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
2506: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
2507: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
2508: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;

Line 2505: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;

2501: l_org_id NUMBER := NULL;
2502: l_resource_type_id pa_resource_types.resource_type_id%TYPE;
2503: l_person_id pa_resource_txn_attributes.person_id%TYPE;
2504: l_job_id pa_resource_txn_attributes.job_id%TYPE;
2505: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
2506: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
2507: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
2508: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
2509: l_event_type pa_resource_txn_attributes.event_type%TYPE;

Line 2506: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;

2502: l_resource_type_id pa_resource_types.resource_type_id%TYPE;
2503: l_person_id pa_resource_txn_attributes.person_id%TYPE;
2504: l_job_id pa_resource_txn_attributes.job_id%TYPE;
2505: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
2506: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
2507: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
2508: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
2509: l_event_type pa_resource_txn_attributes.event_type%TYPE;
2510: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;

Line 2507: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;

2503: l_person_id pa_resource_txn_attributes.person_id%TYPE;
2504: l_job_id pa_resource_txn_attributes.job_id%TYPE;
2505: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
2506: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
2507: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
2508: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
2509: l_event_type pa_resource_txn_attributes.event_type%TYPE;
2510: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
2511: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;

Line 2508: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;

2504: l_job_id pa_resource_txn_attributes.job_id%TYPE;
2505: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
2506: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
2507: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
2508: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
2509: l_event_type pa_resource_txn_attributes.event_type%TYPE;
2510: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
2511: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
2512: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;

Line 2509: l_event_type pa_resource_txn_attributes.event_type%TYPE;

2505: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
2506: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
2507: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
2508: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
2509: l_event_type pa_resource_txn_attributes.event_type%TYPE;
2510: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
2511: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
2512: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;
2513: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;

Line 2510: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;

2506: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
2507: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
2508: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
2509: l_event_type pa_resource_txn_attributes.event_type%TYPE;
2510: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
2511: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
2512: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;
2513: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;
2514: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;

Line 2511: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;

2507: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
2508: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
2509: l_event_type pa_resource_txn_attributes.event_type%TYPE;
2510: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
2511: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
2512: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;
2513: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;
2514: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;
2515: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;

Line 2512: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;

2508: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
2509: l_event_type pa_resource_txn_attributes.event_type%TYPE;
2510: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
2511: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
2512: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;
2513: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;
2514: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;
2515: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;
2516: l_resource_format_id pa_resource_txn_attributes.resource_format_id%TYPE;

Line 2513: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;

2509: l_event_type pa_resource_txn_attributes.event_type%TYPE;
2510: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
2511: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
2512: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;
2513: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;
2514: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;
2515: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;
2516: l_resource_format_id pa_resource_txn_attributes.resource_format_id%TYPE;
2517: l_res_type_code pa_resource_types.resource_type_code%TYPE;

Line 2514: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;

2510: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
2511: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
2512: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;
2513: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;
2514: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;
2515: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;
2516: l_resource_format_id pa_resource_txn_attributes.resource_format_id%TYPE;
2517: l_res_type_code pa_resource_types.resource_type_code%TYPE;
2518:

Line 2515: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;

2511: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
2512: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;
2513: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;
2514: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;
2515: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;
2516: l_resource_format_id pa_resource_txn_attributes.resource_format_id%TYPE;
2517: l_res_type_code pa_resource_types.resource_type_code%TYPE;
2518:
2519:

Line 2516: l_resource_format_id pa_resource_txn_attributes.resource_format_id%TYPE;

2512: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;
2513: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;
2514: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;
2515: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;
2516: l_resource_format_id pa_resource_txn_attributes.resource_format_id%TYPE;
2517: l_res_type_code pa_resource_types.resource_type_code%TYPE;
2518:
2519:
2520: CURSOR c_res_list_csr IS

Line 2540: pa_resource_txn_attributes rta

2536: rta.expenditure_category
2537: FROM
2538: pa_resource_list_members rlm,
2539: pa_resources re,
2540: pa_resource_txn_attributes rta
2541: WHERE rlm.resource_list_member_id = p_parent_member_id
2542: AND rlm.resource_id = re.resource_id
2543: AND re.resource_id = rta.resource_id;
2544:

Line 2551: pa_resource_txn_attributes rta

2547: rta.revenue_category
2548: FROM
2549: pa_resource_list_members rlm,
2550: pa_resources re,
2551: pa_resource_txn_attributes rta
2552: WHERE rlm.resource_list_member_id = p_parent_member_id
2553: AND rlm.resource_id = re.resource_id
2554: AND re.resource_id = rta.resource_id;
2555:

Line 2663: FROM PA_RESOURCE_TXN_ATTRIBUTES PRTA,

2659: prta.system_linkage_function,
2660: prta.resource_format_id,
2661: prt.resource_type_id,
2662: prt.resource_type_code
2663: FROM PA_RESOURCE_TXN_ATTRIBUTES PRTA,
2664: PA_RESOURCES PR,
2665: PA_RESOURCE_TYPES PRT
2666: WHERE prta.resource_id = pr.resource_id
2667: AND pr.resource_id =P_RESOURCE_ID