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 955: PSP_ORGANIZATION_ACCOUNTS POS

951: FROM PSP_ENC_LINES PEL,
952: PER_TIME_PERIODS PTP,
953: -- ,GL_SETS_OF_BOOKS SOB,
954: -- GL_CODE_COMBINATIONS GCC,
955: PSP_ORGANIZATION_ACCOUNTS POS
956: WHERE PEL.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID
957: -- AND PEL.ENCUMBRANCE_DATE BETWEEN PTP.START_DATE AND PTP.END_DATE
958: -- Commented out for bug fix 1971612
959: AND PEL.GL_PROJECT_FLAG = 'G'

Line 1003: -- PSP_ORGANIZATION_ACCOUNTS POS

999: FROM PSP_ENC_LINES PEL,
1000: PER_TIME_PERIODS PTP
1001: -- ,GL_SETS_OF_BOOKS SOB,
1002: -- GL_CODE_COMBINATIONS GCC,
1003: -- PSP_ORGANIZATION_ACCOUNTS POS
1004: WHERE PEL.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID
1005: -- AND PEL.ENCUMBRANCE_DATE BETWEEN PTP.START_DATE AND PTP.END_DATE
1006: -- Commented out for bug fix 1971612
1007: AND PEL.GL_PROJECT_FLAG = 'G'

Line 1037: -- PSP_ORGANIZATION_ACCOUNTS POS

1033: FROM PSP_ENC_LINES PEL,
1034: PER_TIME_PERIODS PTP
1035: -- ,GL_SETS_OF_BOOKS SOB,
1036: -- GL_CODE_COMBINATIONS GCC,
1037: -- PSP_ORGANIZATION_ACCOUNTS POS
1038: WHERE PEL.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID
1039: -- AND PEL.ENCUMBRANCE_DATE BETWEEN PTP.START_DATE AND PTP.END_DATE
1040: -- Commented out for bug fix 1971612
1041: AND PEL.GL_PROJECT_FLAG = 'G'

Line 1076: -- PSP_ORGANIZATION_ACCOUNTS POS

1072: FROM PSP_ENC_LINES PEL,
1073: GL_PERIODS GLP,
1074: GL_SETS_OF_BOOKS SOB,
1075: -- ,GL_CODE_COMBINATIONS GCC,
1076: -- PSP_ORGANIZATION_ACCOUNTS POS
1077: WHERE sob.accounted_period_type = glp.period_type
1078: AND sob.set_of_books_id = g_set_of_books_id
1079: AND PEL.GL_PROJECT_FLAG = 'G'
1080: AND PEL.ENCUMBRANCE_AMOUNT <> 0

Line 1108: -- PSP_ORGANIZATION_ACCOUNTS POS

1104: FROM PSP_ENC_LINES PEL,
1105: GL_PERIODS GLP,
1106: GL_SETS_OF_BOOKS SOB
1107: -- ,GL_CODE_COMBINATIONS GCC,
1108: -- PSP_ORGANIZATION_ACCOUNTS POS
1109: WHERE sob.set_of_books_id = g_set_of_books_id
1110: AND sob.accounted_period_type = glp.period_type
1111: AND PEL.GL_PROJECT_FLAG = 'G'
1112: AND PEL.ENCUMBRANCE_AMOUNT <> 0

Line 1138: -- PSP_ORGANIZATION_ACCOUNTS POS

1134: FROM PSP_ENC_LINES PEL,
1135: GL_PERIODS GLP,
1136: GL_SETS_OF_BOOKS SOB
1137: -- ,GL_CODE_COMBINATIONS GCC,
1138: -- PSP_ORGANIZATION_ACCOUNTS POS
1139: WHERE sob.set_of_books_id = g_set_of_books_id
1140: AND sob.accounted_period_type = glp.period_type
1141: AND PEL.GL_PROJECT_FLAG = 'G'
1142: AND PEL.ENCUMBRANCE_AMOUNT <> 0

Line 1302: AND EXISTS (SELECT 1 FROM psp_organization_accounts poa

1298: -- Enhanced the following check to accomodate suspense postings done in this process for bug fix 3194807.
1299: -- ANd gl_code_combination_id =enc_sum_lines_p1_rec.gl_ccid;
1300: AND ( (suspense_org_account_id IS NOT NULL
1301: AND suspense_reason_code like 'ES:%'
1302: AND EXISTS (SELECT 1 FROM psp_organization_accounts poa
1303: WHERE poa.organization_account_id = suspense_org_account_id
1304: AND poa.gl_code_combination_id = enc_sum_lines_p1_rec.gl_ccid))
1305: OR gl_code_combination_id = enc_sum_lines_p1_rec.gl_ccid);
1306: -- Introduced ELSE portion for bug fix 2908859

Line 1320: AND EXISTS (SELECT 1 FROM psp_organization_accounts poa

1316: AND gl_project_flag = enc_sum_lines_p1_rec.gl_project_flag
1317: AND trunc(encumbrance_date) = trunc(enc_sum_lines_p1_rec.eff_dt) --- added for 3462452
1318: AND ( (suspense_org_account_id IS NOT NULL
1319: AND suspense_reason_code like 'ES:%'
1320: AND EXISTS (SELECT 1 FROM psp_organization_accounts poa
1321: WHERE poa.organization_account_id = suspense_org_account_id
1322: AND poa.gl_code_combination_id = enc_sum_lines_p1_rec.gl_ccid
1323: AND NVL(poa.attribute_category, 'NULL') =
1324: NVL(enc_sum_lines_p1_rec.attribute_category, 'NULL')

Line 2725: FROM hr_all_organization_units hou, psp_organization_accounts poa

2721: -- Get the Organization details ...
2722:
2723: CURSOR get_susp_org_cur(P_ORG_ID IN VARCHAR2) IS
2724: SELECT hou.organization_id, hou.name, poa.gl_code_combination_id
2725: FROM hr_all_organization_units hou, psp_organization_accounts poa
2726: WHERE hou.organization_id = poa.organization_id
2727: AND poa.business_group_id = p_business_group_id
2728: AND poa.set_of_books_id = p_set_of_books_id
2729: AND poa.organization_account_id = p_org_id;

Line 2794: FROM psp_organization_accounts poa

2790: poa.expenditure_organization_id,
2791: poa.expenditure_type,
2792: poa.award_id,
2793: poa.task_id
2794: FROM psp_organization_accounts poa
2795: WHERE poa.organization_id = p_organization_id
2796: AND poa.business_group_id = p_business_group_id
2797: AND poa.set_of_books_id = p_set_of_books_id
2798: AND poa.account_type_code = 'S'

Line 2811: FROM psp_organization_accounts poa

2807: poa.expenditure_organization_id,
2808: poa.expenditure_type,
2809: poa.award_id,
2810: poa.task_id
2811: FROM psp_organization_accounts poa
2812: WHERE
2813: / * poa.account_type_code = 'G'
2814: AND poa.business_group_id = p_business_group_id
2815: AND poa.set_of_books_id = p_set_of_books_id

Line 3199: FROM psp_organization_accounts poa

3195:
3196: / * Introduced this cursor for Bug fix 3194807 * /
3197: UPDATE psp_enc_lines
3198: SET gl_code_combination_id = (SELECT poa.gl_code_combination_id
3199: FROM psp_organization_accounts poa
3200: where poa.organization_account_id = suspense_org_account_id),
3201: project_id = NULL,
3202: task_id = NULL,
3203: award_id = NULL,

Line 3352: psp_organization_accounts poa

3348:
3349: CURSOR get_susp_org_cur(P_ORG_ID IN VARCHAR2) IS
3350: SELECT hou.organization_id, hou.name, poa.gl_code_combination_id
3351: FROM hr_all_organization_units hou,
3352: psp_organization_accounts poa
3353: WHERE hou.organization_id = poa.organization_id
3354: AND poa.business_group_id = p_business_group_id
3355: AND poa.set_of_books_id = p_set_of_books_id
3356: AND poa.organization_account_id = p_org_id;

Line 3378: FROM psp_organization_accounts poa

3374: poa.expenditure_organization_id,
3375: poa.expenditure_type,
3376: poa.award_id,
3377: poa.task_id
3378: FROM psp_organization_accounts poa
3379: WHERE poa.organization_id = p_organization_id
3380: AND poa.business_group_id = p_business_group_id
3381: AND poa.set_of_books_id = p_set_of_books_id
3382: AND poa.account_type_code = 'S'

Line 3393: FROM psp_organization_accounts poa

3389: poa.expenditure_organization_id,
3390: poa.expenditure_type,
3391: poa.award_id,
3392: poa.task_id
3393: FROM psp_organization_accounts poa
3394: WHERE organization_account_id = p_organization_account_id;
3395:
3396: l_encumbrance_date DATE;
3397: l_lines_glccid NUMBER(15);

Line 4060: PSP_ORGANIZATION_ACCOUNTS POA

4056: pel.expenditure_organization_id * /
4057: -- ,pai.set_of_books_id
4058: FROM PSP_ENC_LINES PEL,
4059: PER_TIME_PERIODS PTP,
4060: PSP_ORGANIZATION_ACCOUNTS POA
4061: -- ,PA_IMPLEMENTATIONS_ALL PAI
4062: WHERE PEL.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID
4063: -- AND PEL.ENCUMBRANCE_DATE BETWEEN PTP.START_DATE AND PTP.END_DATE
4064: -- Commented out for bug fix 1971612

Line 4279: AND EXISTS (SELECT 1 FROM psp_organization_accounts poa

4275: WHERE -- project_id = enc_sum_lines_p_rec.project_id Commented for bug fix 3194807
4276: -- Introduced the suspense_org_account verification for bug fix 3194807
4277: ( (suspense_org_account_id IS NOT NULL
4278: AND suspense_reason_code like 'ES:%'
4279: AND EXISTS (SELECT 1 FROM psp_organization_accounts poa
4280: WHERE poa.organization_account_id = suspense_org_account_id
4281: AND poa.project_id = enc_sum_lines_p_rec.project_id
4282: AND poa.task_id = enc_sum_lines_p_rec.task_id
4283: AND poa.expenditure_organization_id = enc_sum_lines_p_rec.expenditure_organization_id

Line 4318: AND EXISTS (SELECT 1 FROM psp_organization_accounts poa

4314: AND gl_project_flag = enc_sum_lines_p_rec.gl_project_flag
4315: AND trunc(encumbrance_date) = trunc(enc_sum_lines_p_rec.eff_dt) --- added for 3462452
4316: AND ( (suspense_org_account_id IS NOT NULL
4317: AND suspense_reason_code like 'ES:%'
4318: AND EXISTS (SELECT 1 FROM psp_organization_accounts poa
4319: WHERE poa.organization_account_id = suspense_org_account_id
4320: AND poa.project_id = enc_sum_lines_p_rec.project_id
4321: AND poa.task_id = enc_sum_lines_p_rec.task_id
4322: AND poa.expenditure_organization_id = enc_sum_lines_p_rec.expenditure_organization_id

Line 5076: FROM hr_all_organization_units hou, psp_organization_accounts poa

5072: -- Get the Organization details ...
5073:
5074: CURSOR get_susp_org_cur(P_ORG_ID IN VARCHAR2) IS
5075: SELECT hou.organization_id, hou.name
5076: FROM hr_all_organization_units hou, psp_organization_accounts poa
5077: WHERE hou.organization_id = poa.organization_id
5078: AND poa.business_group_id = p_business_group_id
5079: AND poa.set_of_books_id = p_set_of_books_id
5080: AND poa.organization_account_id = p_org_id;

Line 5143: FROM psp_organization_accounts poa

5139: poa.expenditure_organization_id,
5140: poa.expenditure_type,
5141: poa.award_id,
5142: poa.task_id
5143: FROM psp_organization_accounts poa
5144: WHERE poa.organization_id = p_organization_id
5145: AND poa.business_group_id = p_business_group_id
5146: AND poa.set_of_books_id = p_set_of_books_id
5147: AND poa.account_type_code = 'S'

Line 5161: FROM psp_organization_accounts poa

5157: poa.expenditure_organization_id,
5158: poa.expenditure_type,
5159: poa.award_id,
5160: poa.task_id
5161: FROM psp_organization_accounts poa
5162: WHERE
5163: / * poa.account_type_code = 'G'
5164: AND poa.business_group_id = p_business_group_id
5165: AND poa.set_of_books_id = p_set_of_books_id

Line 5626: from psp_organization_accounts poa

5622:
5623: UPDATE psp_enc_lines
5624: SET (gl_code_combination_id,project_id,task_id,award_id,expenditure_organization_id,expenditure_type)
5625: = (select NULL,poa.project_id,poa.task_id,poa.award_id,poa.expenditure_organization_id,poa.expenditure_type
5626: from psp_organization_accounts poa
5627: where poa.organization_account_id = suspense_org_account_id
5628: and enc_summary_line_id = l_enc_summary_line_id)
5629: WHERE enc_summary_line_id= l_enc_summary_line_id
5630: AND suspense_reason_code like 'ES:%';

Line 5785: psp_organization_accounts poa

5781:
5782: CURSOR get_susp_org_cur(P_ORG_ID IN VARCHAR2) IS
5783: SELECT hou.organization_id, hou.name, poa.gl_code_combination_id
5784: FROM hr_all_organization_units hou,
5785: psp_organization_accounts poa
5786: WHERE hou.organization_id = poa.organization_id
5787: AND poa.business_group_id = p_business_group_id
5788: AND poa.set_of_books_id = p_set_of_books_id
5789: AND poa.organization_account_id = p_org_id;

Line 5811: FROM psp_organization_accounts poa

5807: poa.expenditure_organization_id,
5808: poa.expenditure_type,
5809: poa.award_id,
5810: poa.task_id
5811: FROM psp_organization_accounts poa
5812: WHERE poa.organization_id = p_organization_id
5813: AND poa.business_group_id = p_business_group_id
5814: AND poa.set_of_books_id = p_set_of_books_id
5815: AND poa.account_type_code = 'S'

Line 5826: FROM psp_organization_accounts poa

5822: poa.expenditure_organization_id,
5823: poa.expenditure_type,
5824: poa.award_id,
5825: poa.task_id
5826: FROM psp_organization_accounts poa
5827: WHERE organization_account_id = p_organization_account_id;
5828:
5829: CURSOR txn_interface_count_cur IS
5830: SELECT COUNT(1)