DBA Data[Home] [Help]

APPS.CST_PRJMFG_COST_COLLECTOR dependencies on PJM_ORG_PARAMETERS

Line 2629: pjm_org_parameters pop

2625: NULL cost_element_id,
2626: p_denom_currency_code denom_currency_code
2627: FROM mtl_material_transactions mmt,
2628: pjm_project_parameters ppp,
2629: pjm_org_parameters pop
2630: WHERE mmt.transaction_id = decode(ppv_txfr_flag,1, p_transfer_transaction_id,
2631: p_transaction_id)
2632: AND mmt.organization_id = decode(ppv_txfr_flag,1,p_transfer_organization_id,
2633: p_organization_id)

Line 2750: FROM pjm_org_parameters pop,

2746: l_stmt_num := 25;
2747:
2748: SELECT max(pop.common_project_id)
2749: INTO l_default_project
2750: FROM pjm_org_parameters pop,
2751: mtl_material_transactions mmt
2752: WHERE pop.organization_id = mmt.organization_id
2753: AND mmt.transaction_id = p_transaction_id;
2754:

Line 3377: from pjm_org_parameters

3373: select NVL(pa_posting_flag,'N'),
3374: NVL(pa_autoaccounting_flag,'N')
3375: into l_blue_print_enabled_flag,
3376: l_autoaccounting_flag
3377: from pjm_org_parameters
3378: where organization_id = l_org_id ;
3379:
3380: If l_blue_print_enabled_flag = 'Y' then
3381:

Line 3931: from pjm_org_parameters

3927: select NVL(pa_posting_flag,'N'),
3928: NVL(pa_autoaccounting_flag,'N')
3929: into l_blue_print_enabled_flag,
3930: l_autoaccounting_flag
3931: from pjm_org_parameters
3932: where organization_id = l_org_id ;
3933:
3934: If l_blue_print_enabled_flag = 'Y' then
3935:

Line 4652: from pjm_org_parameters

4648: select NVL(pa_posting_flag,'N'),
4649: NVL(pa_autoaccounting_flag,'N')
4650: into l_blue_print_enabled_flag,
4651: l_autoaccounting_flag
4652: from pjm_org_parameters
4653: where organization_id = l_org_id ;
4654:
4655: If l_blue_print_enabled_flag = 'Y' then
4656:

Line 7082: from pjm_org_parameters

7078: Select NVL(pa_posting_flag,'N'),
7079: NVL(pa_autoaccounting_flag,'N')
7080: into l_blue_print_enabled,
7081: l_autoaccounting_flag
7082: from pjm_org_parameters
7083: where organization_id = l_mta_organization_id;
7084: EXCEPTION
7085: WHEN NO_DATA_FOUND then
7086: l_blue_print_enabled := 'N';

Line 7092: FROM pjm_org_parameters

7088: END;
7089: If l_blue_print_enabled = 'Y' AND l_autoaccounting_flag = 'N' then
7090: SELECT NVL(MAX(pjm_clearing_account),-999999)
7091: INTO O_cr_code_combination_id
7092: FROM pjm_org_parameters
7093: where organization_id = l_mta_organization_id;
7094:
7095: O_inv_cr_sub_ledger_id := NULL;
7096:

Line 7210: from pjm_org_parameters

7206: Select NVL(pa_posting_flag,'N'),
7207: NVL(pa_autoaccounting_flag,'N')
7208: into l_blue_print_enabled,
7209: l_autoaccounting_flag
7210: from pjm_org_parameters
7211: where organization_id = l_mta_organization_id;
7212: EXCEPTION
7213: WHEN NO_DATA_FOUND then
7214: l_blue_print_enabled := 'N';

Line 7223: FROM pjm_org_parameters

7219: AND l_blue_print_enabled= 'Y'
7220: AND l_autoaccounting_flag = 'N' then
7221: SELECT NVL(MAX(pjm_clearing_account),-999999)
7222: INTO O_cr_code_combination_id
7223: FROM pjm_org_parameters
7224: where organization_id = l_mta_organization_id;
7225:
7226: O_inv_cr_sub_ledger_id := NULL;
7227: