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 1734: --Description: This procedure inserts rows into pa_resource_txn_attributes...

1730:
1731: END chk_plan_rl_unique;
1732: --Name: Create_Resource_txn_Attribute
1733: --Type: Procedure
1734: --Description: This procedure inserts rows into pa_resource_txn_attributes...
1735: --
1736: --Called subprograms: ?
1737: --
1738: --History:

Line 1830: SELECT pa_resource_txn_attributes_s.NEXTVAL

1826:
1827: /* Bug # 932398 Fix : Added flags for non-labor resources in the above cursor */
1828:
1829: CURSOR c_res_txn_attr_seq_csr IS
1830: SELECT pa_resource_txn_attributes_s.NEXTVAL
1831: FROM SYS.DUAL;
1832:
1833: BEGIN
1834: l_old_stack := p_err_stack;

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

1905: ELSE
1906: CLOSE c_res_format_csr;
1907: END IF;
1908:
1909: p_err_stage := 'Select pa_resource_txn_attributes_s.nextval from sys.dual ';
1910:
1911: OPEN c_res_txn_attr_seq_csr;
1912: FETCH c_res_txn_attr_seq_csr INTO
1913: l_resource_txn_attribute_id;

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

1917: ELSE
1918: CLOSE c_res_txn_attr_seq_csr;
1919: END IF;
1920:
1921: p_err_stage := 'Insert into pa_resource_txn_attributes ';
1922:
1923: INSERT INTO pa_resource_txn_attributes
1924: (
1925: resource_txn_attribute_id,

Line 1923: INSERT INTO pa_resource_txn_attributes

1919: END IF;
1920:
1921: p_err_stage := 'Insert into pa_resource_txn_attributes ';
1922:
1923: INSERT INTO pa_resource_txn_attributes
1924: (
1925: resource_txn_attribute_id,
1926: resource_id ,
1927: person_id,

Line 2851: l_person_id pa_resource_txn_attributes.person_id%TYPE;

2847: l_alias VARCHAR2(80); -- Bug 9683569
2848: l_new_track_as_labor_flag VARCHAR2(1);
2849: l_org_id NUMBER := NULL;
2850: l_resource_type_id pa_resource_types.resource_type_id%TYPE;
2851: l_person_id pa_resource_txn_attributes.person_id%TYPE;
2852: l_job_id pa_resource_txn_attributes.job_id%TYPE;
2853: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
2854: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
2855: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;

Line 2852: l_job_id pa_resource_txn_attributes.job_id%TYPE;

2848: l_new_track_as_labor_flag VARCHAR2(1);
2849: l_org_id NUMBER := NULL;
2850: l_resource_type_id pa_resource_types.resource_type_id%TYPE;
2851: l_person_id pa_resource_txn_attributes.person_id%TYPE;
2852: l_job_id pa_resource_txn_attributes.job_id%TYPE;
2853: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
2854: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
2855: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
2856: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;

Line 2853: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;

2849: l_org_id NUMBER := NULL;
2850: l_resource_type_id pa_resource_types.resource_type_id%TYPE;
2851: l_person_id pa_resource_txn_attributes.person_id%TYPE;
2852: l_job_id pa_resource_txn_attributes.job_id%TYPE;
2853: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
2854: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
2855: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
2856: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
2857: l_event_type pa_resource_txn_attributes.event_type%TYPE;

Line 2854: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;

2850: l_resource_type_id pa_resource_types.resource_type_id%TYPE;
2851: l_person_id pa_resource_txn_attributes.person_id%TYPE;
2852: l_job_id pa_resource_txn_attributes.job_id%TYPE;
2853: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
2854: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
2855: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
2856: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
2857: l_event_type pa_resource_txn_attributes.event_type%TYPE;
2858: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;

Line 2855: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;

2851: l_person_id pa_resource_txn_attributes.person_id%TYPE;
2852: l_job_id pa_resource_txn_attributes.job_id%TYPE;
2853: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
2854: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
2855: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
2856: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
2857: l_event_type pa_resource_txn_attributes.event_type%TYPE;
2858: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
2859: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;

Line 2856: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;

2852: l_job_id pa_resource_txn_attributes.job_id%TYPE;
2853: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
2854: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
2855: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
2856: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
2857: l_event_type pa_resource_txn_attributes.event_type%TYPE;
2858: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
2859: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
2860: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;

Line 2857: l_event_type pa_resource_txn_attributes.event_type%TYPE;

2853: l_organization_id pa_resource_txn_attributes.organization_id%TYPE;
2854: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
2855: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
2856: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
2857: l_event_type pa_resource_txn_attributes.event_type%TYPE;
2858: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
2859: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
2860: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;
2861: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;

Line 2858: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;

2854: l_vendor_id pa_resource_txn_attributes.vendor_id%TYPE;
2855: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
2856: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
2857: l_event_type pa_resource_txn_attributes.event_type%TYPE;
2858: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
2859: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
2860: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;
2861: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;
2862: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;

Line 2859: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;

2855: l_project_role_id pa_resource_txn_attributes.project_role_id%TYPE;
2856: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
2857: l_event_type pa_resource_txn_attributes.event_type%TYPE;
2858: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
2859: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
2860: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;
2861: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;
2862: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;
2863: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;

Line 2860: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;

2856: l_expenditure_type pa_resource_txn_attributes.expenditure_type%TYPE;
2857: l_event_type pa_resource_txn_attributes.event_type%TYPE;
2858: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
2859: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
2860: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;
2861: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;
2862: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;
2863: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;
2864: l_resource_format_id pa_resource_txn_attributes.resource_format_id%TYPE;

Line 2861: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;

2857: l_event_type pa_resource_txn_attributes.event_type%TYPE;
2858: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
2859: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
2860: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;
2861: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;
2862: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;
2863: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;
2864: l_resource_format_id pa_resource_txn_attributes.resource_format_id%TYPE;
2865: l_res_type_code pa_resource_types.resource_type_code%TYPE;

Line 2862: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;

2858: l_expenditure_category pa_resource_txn_attributes.expenditure_category%TYPE;
2859: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
2860: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;
2861: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;
2862: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;
2863: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;
2864: l_resource_format_id pa_resource_txn_attributes.resource_format_id%TYPE;
2865: l_res_type_code pa_resource_types.resource_type_code%TYPE;
2866:

Line 2863: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;

2859: l_revenue_category pa_resource_txn_attributes.revenue_category%TYPE;
2860: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;
2861: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;
2862: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;
2863: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;
2864: l_resource_format_id pa_resource_txn_attributes.resource_format_id%TYPE;
2865: l_res_type_code pa_resource_types.resource_type_code%TYPE;
2866:
2867:

Line 2864: l_resource_format_id pa_resource_txn_attributes.resource_format_id%TYPE;

2860: l_nlr_resource pa_resource_txn_attributes.non_labor_resource%TYPE;
2861: l_nlr_res_org_id pa_resource_txn_attributes.non_labor_resource_org_id%TYPE;
2862: l_event_type_cls pa_resource_txn_attributes.event_type_classification%TYPE;
2863: l_system_link_function pa_resource_txn_attributes.system_linkage_function%TYPE;
2864: l_resource_format_id pa_resource_txn_attributes.resource_format_id%TYPE;
2865: l_res_type_code pa_resource_types.resource_type_code%TYPE;
2866:
2867:
2868: CURSOR c_res_list_csr IS

Line 2888: pa_resource_txn_attributes rta

2884: rta.expenditure_category
2885: FROM
2886: pa_resource_list_members rlm,
2887: pa_resources re,
2888: pa_resource_txn_attributes rta
2889: WHERE rlm.resource_list_member_id = p_parent_member_id
2890: AND rlm.resource_id = re.resource_id
2891: AND re.resource_id = rta.resource_id;
2892:

Line 2899: pa_resource_txn_attributes rta

2895: rta.revenue_category
2896: FROM
2897: pa_resource_list_members rlm,
2898: pa_resources re,
2899: pa_resource_txn_attributes rta
2900: WHERE rlm.resource_list_member_id = p_parent_member_id
2901: AND rlm.resource_id = re.resource_id
2902: AND re.resource_id = rta.resource_id;
2903:

Line 3011: FROM PA_RESOURCE_TXN_ATTRIBUTES PRTA,

3007: prta.system_linkage_function,
3008: prta.resource_format_id,
3009: prt.resource_type_id,
3010: prt.resource_type_code
3011: FROM PA_RESOURCE_TXN_ATTRIBUTES PRTA,
3012: PA_RESOURCES PR,
3013: PA_RESOURCE_TYPES PRT
3014: WHERE prta.resource_id = pr.resource_id
3015: AND pr.resource_id =P_RESOURCE_ID