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

Line 31: , psp_organization_accounts poa

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , psp_organization_accounts poa
32: where poa.organization_account_id = p_organization_account_id
33: and pbg.business_group_id = poa.business_group_id;
34: --
35: -- Declare local variables

Line 101: , psp_organization_accounts poa

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , psp_organization_accounts poa
102: where poa.organization_account_id = p_organization_account_id
103: and pbg.business_group_id = poa.business_group_id;
104: --
105: -- Declare local variables

Line 355: FROM psp_organization_accounts

351: --Cursor date_selection_csr: Select the dates for the accounts(other than the current one) of this organization.
352:
353: CURSOR date_selection_csr IS
354: SELECT start_date_active, end_date_active
355: FROM psp_organization_accounts
356: WHERE organization_id = p_organization_id
357: AND account_type_code = p_account_type
358: AND business_group_id = p_per_business_group_id
359: AND set_of_books_id = p_gl_set_of_bks_id