APPS.PA_FP_TXN_CURRENCIES_PUB dependencies on PA_PROJECTS_ALL

Line 45: l_source_project_id pa_projects_all.project_id%TYPE;

41:
42:
43: /* End of Variables to be used for debugging purpose */
44:
45: l_source_project_id pa_projects_all.project_id%TYPE;
46: l_source_fp_option_id pa_proj_fp_options.proj_fp_options_id%TYPE;
47:
48: l_srce_cost_default_curr_code pa_fp_txn_currencies.txn_currency_code%TYPE;
49: l_srce_rev_default_curr_code pa_fp_txn_currencies.txn_currency_code%TYPE;

Line 69: FROM pa_projects_all

65:
66: CURSOR proj_pf_currencies_cur(c_project_id pa_projects.project_id%TYPE) IS
67: SELECT project_currency_code
68: ,projfunc_currency_code
69: FROM pa_projects_all
70: WHERE project_id = c_project_id;
71:
72: proj_pf_currencies_rec proj_pf_currencies_cur%ROWTYPE;
73:

Line 859: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

855: l_agreement_num pa_agreements_all.agreement_num%TYPE;
856: l_agreement_amount pa_agreements_all.amount%TYPE;
857: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
858:
859: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
860: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
861: l_dummy_currency_code pa_projects_all.projfunc_currency_code%TYPE;
862:
863:

Line 860: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

856: l_agreement_amount pa_agreements_all.amount%TYPE;
857: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
858:
859: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
860: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
861: l_dummy_currency_code pa_projects_all.projfunc_currency_code%TYPE;
862:
863:
864: CURSOR version_details_cur IS

Line 861: l_dummy_currency_code pa_projects_all.projfunc_currency_code%TYPE;

857: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
858:
859: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
860: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
861: l_dummy_currency_code pa_projects_all.projfunc_currency_code%TYPE;
862:
863:
864: CURSOR version_details_cur IS
865: SELECT proj_fp_options_id,