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.PSP_ENC_SUM_TRAN dependencies on PSP_ORGANIZATION_ACCOUNTS

Line 975: PSP_ORGANIZATION_ACCOUNTS POS

971: FROM PSP_ENC_LINES PEL,
972: PER_TIME_PERIODS PTP,
973: -- ,GL_SETS_OF_BOOKS SOB,
974: -- GL_CODE_COMBINATIONS GCC,
975: PSP_ORGANIZATION_ACCOUNTS POS
976: WHERE PEL.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID
977: -- AND PEL.ENCUMBRANCE_DATE BETWEEN PTP.START_DATE AND PTP.END_DATE
978: -- Commented out for bug fix 1971612
979: AND PEL.GL_PROJECT_FLAG = 'G'

Line 1023: -- PSP_ORGANIZATION_ACCOUNTS POS

1019: FROM PSP_ENC_LINES PEL,
1020: PER_TIME_PERIODS PTP
1021: -- ,GL_SETS_OF_BOOKS SOB,
1022: -- GL_CODE_COMBINATIONS GCC,
1023: -- PSP_ORGANIZATION_ACCOUNTS POS
1024: WHERE PEL.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID
1025: -- AND PEL.ENCUMBRANCE_DATE BETWEEN PTP.START_DATE AND PTP.END_DATE
1026: -- Commented out for bug fix 1971612
1027: AND PEL.GL_PROJECT_FLAG = 'G'

Line 1057: -- PSP_ORGANIZATION_ACCOUNTS POS

1053: FROM PSP_ENC_LINES PEL,
1054: PER_TIME_PERIODS PTP
1055: -- ,GL_SETS_OF_BOOKS SOB,
1056: -- GL_CODE_COMBINATIONS GCC,
1057: -- PSP_ORGANIZATION_ACCOUNTS POS
1058: WHERE PEL.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID
1059: -- AND PEL.ENCUMBRANCE_DATE BETWEEN PTP.START_DATE AND PTP.END_DATE
1060: -- Commented out for bug fix 1971612
1061: AND PEL.GL_PROJECT_FLAG = 'G'

Line 1096: -- PSP_ORGANIZATION_ACCOUNTS POS

1092: FROM PSP_ENC_LINES PEL,
1093: GL_PERIODS GLP,
1094: GL_SETS_OF_BOOKS SOB,
1095: -- ,GL_CODE_COMBINATIONS GCC,
1096: -- PSP_ORGANIZATION_ACCOUNTS POS
1097: WHERE sob.accounted_period_type = glp.period_type
1098: AND sob.set_of_books_id = g_set_of_books_id
1099: AND PEL.GL_PROJECT_FLAG = 'G'
1100: AND PEL.ENCUMBRANCE_AMOUNT <> 0

Line 1128: -- PSP_ORGANIZATION_ACCOUNTS POS

1124: FROM PSP_ENC_LINES PEL,
1125: GL_PERIODS GLP,
1126: GL_SETS_OF_BOOKS SOB
1127: -- ,GL_CODE_COMBINATIONS GCC,
1128: -- PSP_ORGANIZATION_ACCOUNTS POS
1129: WHERE sob.set_of_books_id = g_set_of_books_id
1130: AND sob.accounted_period_type = glp.period_type
1131: AND PEL.GL_PROJECT_FLAG = 'G'
1132: AND PEL.ENCUMBRANCE_AMOUNT <> 0

Line 1158: -- PSP_ORGANIZATION_ACCOUNTS POS

1154: FROM PSP_ENC_LINES PEL,
1155: GL_PERIODS GLP,
1156: GL_SETS_OF_BOOKS SOB
1157: -- ,GL_CODE_COMBINATIONS GCC,
1158: -- PSP_ORGANIZATION_ACCOUNTS POS
1159: WHERE sob.set_of_books_id = g_set_of_books_id
1160: AND sob.accounted_period_type = glp.period_type
1161: AND PEL.GL_PROJECT_FLAG = 'G'
1162: AND PEL.ENCUMBRANCE_AMOUNT <> 0

Line 1322: AND EXISTS (SELECT 1 FROM psp_organization_accounts poa

1318: -- Enhanced the following check to accomodate suspense postings done in this process for bug fix 3194807.
1319: -- ANd gl_code_combination_id =enc_sum_lines_p1_rec.gl_ccid;
1320: AND ( (suspense_org_account_id IS NOT NULL
1321: AND suspense_reason_code like 'ES:%'
1322: AND EXISTS (SELECT 1 FROM psp_organization_accounts poa
1323: WHERE poa.organization_account_id = suspense_org_account_id
1324: AND poa.gl_code_combination_id = enc_sum_lines_p1_rec.gl_ccid))
1325: OR gl_code_combination_id = enc_sum_lines_p1_rec.gl_ccid);
1326: -- Introduced ELSE portion for bug fix 2908859

Line 1340: AND EXISTS (SELECT 1 FROM psp_organization_accounts poa

1336: AND gl_project_flag = enc_sum_lines_p1_rec.gl_project_flag
1337: AND trunc(encumbrance_date) = trunc(enc_sum_lines_p1_rec.eff_dt) --- added for 3462452
1338: AND ( (suspense_org_account_id IS NOT NULL
1339: AND suspense_reason_code like 'ES:%'
1340: AND EXISTS (SELECT 1 FROM psp_organization_accounts poa
1341: WHERE poa.organization_account_id = suspense_org_account_id
1342: AND poa.gl_code_combination_id = enc_sum_lines_p1_rec.gl_ccid
1343: AND NVL(poa.attribute_category, 'NULL') =
1344: NVL(enc_sum_lines_p1_rec.attribute_category, 'NULL')

Line 2767: FROM hr_all_organization_units hou, psp_organization_accounts poa

2763: -- Get the Organization details ...
2764:
2765: CURSOR get_susp_org_cur(P_ORG_ID IN VARCHAR2) IS
2766: SELECT hou.organization_id, hou.name, poa.gl_code_combination_id
2767: FROM hr_all_organization_units hou, psp_organization_accounts poa
2768: WHERE hou.organization_id = poa.organization_id
2769: AND poa.business_group_id = p_business_group_id
2770: AND poa.set_of_books_id = p_set_of_books_id
2771: AND poa.organization_account_id = p_org_id;

Line 2836: FROM psp_organization_accounts poa

2832: poa.expenditure_organization_id,
2833: poa.expenditure_type,
2834: poa.award_id,
2835: poa.task_id
2836: FROM psp_organization_accounts poa
2837: WHERE poa.organization_id = p_organization_id
2838: AND poa.business_group_id = p_business_group_id
2839: AND poa.set_of_books_id = p_set_of_books_id
2840: AND poa.account_type_code = 'S'

Line 2853: FROM psp_organization_accounts poa

2849: poa.expenditure_organization_id,
2850: poa.expenditure_type,
2851: poa.award_id,
2852: poa.task_id
2853: FROM psp_organization_accounts poa
2854: WHERE
2855: / * poa.account_type_code = 'G'
2856: AND poa.business_group_id = p_business_group_id
2857: AND poa.set_of_books_id = p_set_of_books_id

Line 3241: FROM psp_organization_accounts poa

3237:
3238: / * Introduced this cursor for Bug fix 3194807 * /
3239: UPDATE psp_enc_lines
3240: SET gl_code_combination_id = (SELECT poa.gl_code_combination_id
3241: FROM psp_organization_accounts poa
3242: where poa.organization_account_id = suspense_org_account_id),
3243: project_id = NULL,
3244: task_id = NULL,
3245: award_id = NULL,

Line 3394: psp_organization_accounts poa

3390:
3391: CURSOR get_susp_org_cur(P_ORG_ID IN VARCHAR2) IS
3392: SELECT hou.organization_id, hou.name, poa.gl_code_combination_id
3393: FROM hr_all_organization_units hou,
3394: psp_organization_accounts poa
3395: WHERE hou.organization_id = poa.organization_id
3396: AND poa.business_group_id = p_business_group_id
3397: AND poa.set_of_books_id = p_set_of_books_id
3398: AND poa.organization_account_id = p_org_id;

Line 3420: FROM psp_organization_accounts poa

3416: poa.expenditure_organization_id,
3417: poa.expenditure_type,
3418: poa.award_id,
3419: poa.task_id
3420: FROM psp_organization_accounts poa
3421: WHERE poa.organization_id = p_organization_id
3422: AND poa.business_group_id = p_business_group_id
3423: AND poa.set_of_books_id = p_set_of_books_id
3424: AND poa.account_type_code = 'S'

Line 3435: FROM psp_organization_accounts poa

3431: poa.expenditure_organization_id,
3432: poa.expenditure_type,
3433: poa.award_id,
3434: poa.task_id
3435: FROM psp_organization_accounts poa
3436: WHERE organization_account_id = p_organization_account_id;
3437:
3438: l_encumbrance_date DATE;
3439: l_lines_glccid NUMBER(15);

Line 4164: PSP_ORGANIZATION_ACCOUNTS POA

4160: pel.expenditure_organization_id * /
4161: -- ,pai.set_of_books_id
4162: FROM PSP_ENC_LINES PEL,
4163: PER_TIME_PERIODS PTP,
4164: PSP_ORGANIZATION_ACCOUNTS POA
4165: -- ,PA_IMPLEMENTATIONS_ALL PAI
4166: WHERE PEL.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID
4167: -- AND PEL.ENCUMBRANCE_DATE BETWEEN PTP.START_DATE AND PTP.END_DATE
4168: -- Commented out for bug fix 1971612

Line 4383: AND EXISTS (SELECT 1 FROM psp_organization_accounts poa

4379: WHERE -- project_id = enc_sum_lines_p_rec.project_id Commented for bug fix 3194807
4380: -- Introduced the suspense_org_account verification for bug fix 3194807
4381: ( (suspense_org_account_id IS NOT NULL
4382: AND suspense_reason_code like 'ES:%'
4383: AND EXISTS (SELECT 1 FROM psp_organization_accounts poa
4384: WHERE poa.organization_account_id = suspense_org_account_id
4385: AND poa.project_id = enc_sum_lines_p_rec.project_id
4386: AND poa.task_id = enc_sum_lines_p_rec.task_id
4387: AND poa.expenditure_organization_id = enc_sum_lines_p_rec.expenditure_organization_id

Line 4422: AND EXISTS (SELECT 1 FROM psp_organization_accounts poa

4418: AND gl_project_flag = enc_sum_lines_p_rec.gl_project_flag
4419: AND trunc(encumbrance_date) = trunc(enc_sum_lines_p_rec.eff_dt) --- added for 3462452
4420: AND ( (suspense_org_account_id IS NOT NULL
4421: AND suspense_reason_code like 'ES:%'
4422: AND EXISTS (SELECT 1 FROM psp_organization_accounts poa
4423: WHERE poa.organization_account_id = suspense_org_account_id
4424: AND poa.project_id = enc_sum_lines_p_rec.project_id
4425: AND poa.task_id = enc_sum_lines_p_rec.task_id
4426: AND poa.expenditure_organization_id = enc_sum_lines_p_rec.expenditure_organization_id

Line 5259: FROM hr_all_organization_units hou, psp_organization_accounts poa

5255: -- Get the Organization details ...
5256:
5257: CURSOR get_susp_org_cur(P_ORG_ID IN VARCHAR2) IS
5258: SELECT hou.organization_id, hou.name
5259: FROM hr_all_organization_units hou, psp_organization_accounts poa
5260: WHERE hou.organization_id = poa.organization_id
5261: AND poa.business_group_id = p_business_group_id
5262: AND poa.set_of_books_id = p_set_of_books_id
5263: AND poa.organization_account_id = p_org_id;

Line 5326: FROM psp_organization_accounts poa

5322: poa.expenditure_organization_id,
5323: poa.expenditure_type,
5324: poa.award_id,
5325: poa.task_id
5326: FROM psp_organization_accounts poa
5327: WHERE poa.organization_id = p_organization_id
5328: AND poa.business_group_id = p_business_group_id
5329: AND poa.set_of_books_id = p_set_of_books_id
5330: AND poa.account_type_code = 'S'

Line 5344: FROM psp_organization_accounts poa

5340: poa.expenditure_organization_id,
5341: poa.expenditure_type,
5342: poa.award_id,
5343: poa.task_id
5344: FROM psp_organization_accounts poa
5345: WHERE
5346: / * poa.account_type_code = 'G'
5347: AND poa.business_group_id = p_business_group_id
5348: AND poa.set_of_books_id = p_set_of_books_id

Line 5809: from psp_organization_accounts poa

5805:
5806: UPDATE psp_enc_lines
5807: SET (gl_code_combination_id,project_id,task_id,award_id,expenditure_organization_id,expenditure_type)
5808: = (select NULL,poa.project_id,poa.task_id,poa.award_id,poa.expenditure_organization_id,poa.expenditure_type
5809: from psp_organization_accounts poa
5810: where poa.organization_account_id = suspense_org_account_id
5811: and enc_summary_line_id = l_enc_summary_line_id)
5812: WHERE enc_summary_line_id= l_enc_summary_line_id
5813: AND suspense_reason_code like 'ES:%';

Line 5968: psp_organization_accounts poa

5964:
5965: CURSOR get_susp_org_cur(P_ORG_ID IN VARCHAR2) IS
5966: SELECT hou.organization_id, hou.name, poa.gl_code_combination_id
5967: FROM hr_all_organization_units hou,
5968: psp_organization_accounts poa
5969: WHERE hou.organization_id = poa.organization_id
5970: AND poa.business_group_id = p_business_group_id
5971: AND poa.set_of_books_id = p_set_of_books_id
5972: AND poa.organization_account_id = p_org_id;

Line 5994: FROM psp_organization_accounts poa

5990: poa.expenditure_organization_id,
5991: poa.expenditure_type,
5992: poa.award_id,
5993: poa.task_id
5994: FROM psp_organization_accounts poa
5995: WHERE poa.organization_id = p_organization_id
5996: AND poa.business_group_id = p_business_group_id
5997: AND poa.set_of_books_id = p_set_of_books_id
5998: AND poa.account_type_code = 'S'

Line 6009: FROM psp_organization_accounts poa

6005: poa.expenditure_organization_id,
6006: poa.expenditure_type,
6007: poa.award_id,
6008: poa.task_id
6009: FROM psp_organization_accounts poa
6010: WHERE organization_account_id = p_organization_account_id;
6011:
6012: CURSOR txn_interface_count_cur IS
6013: SELECT COUNT(1)