APPS.CST_PRJMFG_COST_COLLECTOR dependencies on PJM_ORG_PARAMETERS

Line 2568: pjm_org_parameters pop

2564: NULL cost_element_id,
2565: p_denom_currency_code denom_currency_code
2566: FROM mtl_material_transactions mmt,
2567: pjm_project_parameters ppp,
2568: pjm_org_parameters pop
2569: WHERE mmt.transaction_id = decode(ppv_txfr_flag,1, p_transfer_transaction_id,
2570: p_transaction_id)
2571: AND mmt.organization_id = decode(ppv_txfr_flag,1,p_transfer_organization_id,
2572: p_organization_id)

Line 2689: FROM pjm_org_parameters pop,

2685: l_stmt_num := 25;
2686:
2687: SELECT max(pop.common_project_id)
2688: INTO l_default_project
2689: FROM pjm_org_parameters pop,
2690: mtl_material_transactions mmt
2691: WHERE pop.organization_id = mmt.organization_id
2692: AND mmt.transaction_id = p_transaction_id;
2693:

Line 3316: from pjm_org_parameters

3312: select NVL(pa_posting_flag,'N'),
3313: NVL(pa_autoaccounting_flag,'N')
3314: into l_blue_print_enabled_flag,
3315: l_autoaccounting_flag
3316: from pjm_org_parameters
3317: where organization_id = l_org_id ;
3318:
3319: If l_blue_print_enabled_flag = 'Y' then
3320:

Line 3870: from pjm_org_parameters

3866: select NVL(pa_posting_flag,'N'),
3867: NVL(pa_autoaccounting_flag,'N')
3868: into l_blue_print_enabled_flag,
3869: l_autoaccounting_flag
3870: from pjm_org_parameters
3871: where organization_id = l_org_id ;
3872:
3873: If l_blue_print_enabled_flag = 'Y' then
3874:

Line 4591: from pjm_org_parameters

4587: select NVL(pa_posting_flag,'N'),
4588: NVL(pa_autoaccounting_flag,'N')
4589: into l_blue_print_enabled_flag,
4590: l_autoaccounting_flag
4591: from pjm_org_parameters
4592: where organization_id = l_org_id ;
4593:
4594: If l_blue_print_enabled_flag = 'Y' then
4595:

Line 6862: from pjm_org_parameters

6858: Select NVL(pa_posting_flag,'N'),
6859: NVL(pa_autoaccounting_flag,'N')
6860: into l_blue_print_enabled,
6861: l_autoaccounting_flag
6862: from pjm_org_parameters
6863: where organization_id = l_mta_organization_id;
6864: EXCEPTION
6865: WHEN NO_DATA_FOUND then
6866: l_blue_print_enabled := 'N';

Line 6872: FROM pjm_org_parameters

6868: END;
6869: If l_blue_print_enabled = 'Y' AND l_autoaccounting_flag = 'N' then
6870: SELECT NVL(MAX(pjm_clearing_account),-999999)
6871: INTO O_cr_code_combination_id
6872: FROM pjm_org_parameters
6873: where organization_id = l_mta_organization_id;
6874:
6875: O_inv_cr_sub_ledger_id := NULL;
6876:

Line 6990: from pjm_org_parameters

6986: Select NVL(pa_posting_flag,'N'),
6987: NVL(pa_autoaccounting_flag,'N')
6988: into l_blue_print_enabled,
6989: l_autoaccounting_flag
6990: from pjm_org_parameters
6991: where organization_id = l_mta_organization_id;
6992: EXCEPTION
6993: WHEN NO_DATA_FOUND then
6994: l_blue_print_enabled := 'N';

Line 7003: FROM pjm_org_parameters

6999: AND l_blue_print_enabled= 'Y'
7000: AND l_autoaccounting_flag = 'N' then
7001: SELECT NVL(MAX(pjm_clearing_account),-999999)
7002: INTO O_cr_code_combination_id
7003: FROM pjm_org_parameters
7004: where organization_id = l_mta_organization_id;
7005:
7006: O_inv_cr_sub_ledger_id := NULL;
7007: