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_CREATE_LINES dependencies on PSP_ORGANIZATION_ACCOUNTS

Line 8280: PSP_ORGANIZATION_ACCOUNTS pos,

8276: DECODE(g_dff_grouping_option, 'Y', pel.attribute9, NULL) attribute9,
8277: DECODE(g_dff_grouping_option, 'Y', pel.attribute10, NULL) attribute10,
8278: pa.org_id
8279: FROM PSP_ENC_LINES pel,
8280: PSP_ORGANIZATION_ACCOUNTS pos,
8281: pa_projects_all pa
8282: WHERE pel.ENCUMBRANCE_AMOUNT <> 0
8283: AND pel.assignment_id = p_assignment_id
8284: AND pel.payroll_id = p_payroll_id

Line 9953: FROM psp_organization_accounts poa

9949: DECODE(g_dff_grouping_option, 'Y', poa.attribute8, NULL),
9950: DECODE(g_dff_grouping_option, 'Y', poa.attribute9, NULL),
9951: DECODE(g_dff_grouping_option, 'Y', poa.attribute10, NULL),
9952: DECODE(poa.expenditure_type, NULL, 'N', 'E') acct_type
9953: FROM psp_organization_accounts poa
9954: WHERE poa.organization_id = p_organization_id
9955: AND poa.business_group_id = p_business_group_id
9956: AND poa.set_of_books_id = p_set_of_books_id
9957: AND poa.account_type_code = 'D'

Line 9992: FROM psp_organization_accounts poa

9988: DECODE(g_dff_grouping_option, 'Y', poa.attribute8, NULL),
9989: DECODE(g_dff_grouping_option, 'Y', poa.attribute9, NULL),
9990: DECODE(g_dff_grouping_option, 'Y', poa.attribute10, NULL),
9991: DECODE(poa.expenditure_type, NULL, 'N', 'E') acct_type
9992: FROM psp_organization_accounts poa
9993: WHERE poa.organization_id = p_organization_id
9994: AND poa.business_group_id = p_business_group_id
9995: AND poa.set_of_books_id = p_set_of_books_id
9996: AND poa.account_type_code = 'S'

Line 10029: FROM psp_organization_accounts poa

10025: DECODE(g_dff_grouping_option, 'Y', poa.attribute8, NULL),
10026: DECODE(g_dff_grouping_option, 'Y', poa.attribute9, NULL),
10027: DECODE(g_dff_grouping_option, 'Y', poa.attribute10, NULL),
10028: DECODE(poa.expenditure_type, NULL, 'N', 'E') acct_type
10029: FROM psp_organization_accounts poa
10030: WHERE poa.business_group_id = p_business_group_id
10031: AND poa.set_of_books_id = p_set_of_books_id
10032: AND poa.account_type_code = 'G'
10033: AND poa.start_date_active <= g_enc_org_end_date