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

Line 687: psp_organization_accounts pod,

683: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute9, pos.attribute9), NULL) attribute9,
684: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute10, pos.attribute10), NULL) attribute10
685: ---decode(pdl.suspense_org_account_id, NULL, 'N', 'Y') Suspense_Flag commented for 2663344
686: FROM psp_schedule_lines psl,
687: psp_organization_accounts pod,
688: psp_organization_accounts pos,
689: psp_element_type_accounts pea,
690: psp_default_labor_schedules pdls,
691: psp_payroll_controls ppc,

Line 688: psp_organization_accounts pos,

684: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute10, pos.attribute10), NULL) attribute10
685: ---decode(pdl.suspense_org_account_id, NULL, 'N', 'Y') Suspense_Flag commented for 2663344
686: FROM psp_schedule_lines psl,
687: psp_organization_accounts pod,
688: psp_organization_accounts pos,
689: psp_element_type_accounts pea,
690: psp_default_labor_schedules pdls,
691: psp_payroll_controls ppc,
692: psp_payroll_lines ppl,

Line 737: psp_organization_accounts pos,

733: DECODE(g_dff_grouping_option, 'Y', DECODE(ppg.suspense_org_account_id, NULL, ppg.attribute9, pos.attribute9), NULL) attribute9,
734: DECODE(g_dff_grouping_option, 'Y', DECODE(ppg.suspense_org_account_id, NULL, ppg.attribute10, pos.attribute10), NULL) attribute10
735: ---decode(ppg.suspense_org_Account_id, NULL, 'N', 'Y') Suspense_Flag commented for 2663344
736: FROM psp_pre_gen_dist_lines ppg,
737: psp_organization_accounts pos,
738: psp_payroll_controls ppc
739: WHERE ppg.status_code = 'N'
740: /* changed following condition for bug 2007521 */
741: AND ((ppg.gl_code_combination_id IS NOT NULL and pos.project_id is null)

Line 776: psp_organization_accounts pos,

772: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute10, pos.attribute10), NULL) attribute10
773: FROM psp_payroll_controls ppc,
774: psp_payroll_lines ppl,
775: psp_payroll_sub_lines ppsl,
776: psp_organization_accounts pos,
777: psp_distribution_lines pdl
778: WHERE pdl.status_code = 'N'
779: AND pdl.payroll_sub_line_id = ppsl.payroll_sub_line_id
780: AND ppsl.payroll_line_id = ppl.payroll_line_id

Line 1854: FROM hr_all_organization_units hou, psp_organization_accounts poa

1850: -- Get the Organization details ...
1851:
1852: CURSOR get_susp_org_cur(P_ORG_ID IN VARCHAR2) IS
1853: SELECT hou.organization_id, hou.name, poa.gl_code_combination_id
1854: FROM hr_all_organization_units hou, psp_organization_accounts poa
1855: WHERE hou.organization_id = poa.organization_id
1856: AND poa.business_group_id = p_business_group_id
1857: AND poa.set_of_books_id = p_set_of_books_id
1858: AND poa.organization_account_id = p_org_id;

Line 1899: FROM psp_organization_accounts poa

1895: poa.award_id,
1896: poa.task_id,
1897: poa.expenditure_organization_id,
1898: poa.expenditure_type
1899: FROM psp_organization_accounts poa
1900: WHERE poa.organization_id = p_organization_id
1901: AND poa.account_type_code = 'S'
1902: AND poa.business_group_id = p_business_group_id
1903: AND poa.set_of_books_id = p_set_of_books_id

Line 1917: FROM psp_organization_accounts poa

1913: poa.award_id,
1914: poa.task_id,
1915: poa.expenditure_organization_id,
1916: poa.expenditure_type
1917: FROM psp_organization_accounts poa
1918: WHERE
1919: /* poa.account_type_code = 'G'
1920: AND poa.business_group_id = p_business_group_id
1921: AND poa.set_of_books_id = p_set_of_books_id

Line 2774: psp_organization_accounts pos

2770: ppgd.set_of_books_id,
2771: ppgd.business_group_id,
2772: round(sum(ppgd.distribution_amount), p_precision) reversal_dist_amount -- For Bug 2916848 changed to p_precision
2773: FROM psp_pre_gen_dist_lines ppgd,
2774: psp_organization_accounts pos
2775: WHERE ppgd.payroll_control_id = p_payroll_control_id
2776: AND nvl(ppgd.reversal_entry_flag,'N') = 'N'
2777: AND ((ppgd.gl_code_combination_id IS NOT NULL and pos.project_id is null ) OR -- Bug 2007521 Changed condn
2778: pos.gl_code_combination_id IS NOT NULL)

Line 2915: from psp_pre_gen_dist_lines ppgd, psp_organization_accounts pos

2911:
2912: select sum(decode(reversal_entry_flag, 'Y', distribution_amount, 0)),
2913: sum(decode(reversal_entry_flag, 'Y', 0, distribution_amount))
2914: into l_cr_amount, l_dr_amount
2915: from psp_pre_gen_dist_lines ppgd, psp_organization_accounts pos
2916: where payroll_control_id = p_payroll_control_id
2917: and ppgd.status_code = 'N'
2918: and ppgd.suspense_org_account_id = pos.organization_account_id(+)
2919: AND ((ppgd.gl_code_combination_id IS NOT NULL and ppgd.suspense_org_account_id is null ) OR

Line 3198: psp_organization_accounts pod,

3194: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute9, pos.attribute9), NULL) attribute9,
3195: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute10, pos.attribute10), NULL) attribute10
3196: ---decode(pdl.suspense_org_account_id, NULL, 'N', 'Y') Suspense_Flag uncommented for 2663344
3197: FROM psp_schedule_lines psl,
3198: psp_organization_accounts pod,
3199: psp_organization_accounts pos,
3200: psp_element_type_accounts pea,
3201: psp_default_labor_schedules pdls,
3202: psp_payroll_controls ppc,

Line 3199: psp_organization_accounts pos,

3195: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute10, pos.attribute10), NULL) attribute10
3196: ---decode(pdl.suspense_org_account_id, NULL, 'N', 'Y') Suspense_Flag uncommented for 2663344
3197: FROM psp_schedule_lines psl,
3198: psp_organization_accounts pod,
3199: psp_organization_accounts pos,
3200: psp_element_type_accounts pea,
3201: psp_default_labor_schedules pdls,
3202: psp_payroll_controls ppc,
3203: psp_payroll_lines ppl,

Line 3255: psp_organization_accounts pos,

3251: DECODE(g_dff_grouping_option, 'Y', DECODE(ppg.suspense_org_account_id, NULL, ppg.attribute9, pos.attribute9), NULL) attribute9,
3252: DECODE(g_dff_grouping_option, 'Y', DECODE(ppg.suspense_org_account_id, NULL, ppg.attribute10, pos.attribute10), NULL) attribute10
3253: ---decode(ppg.suspense_org_Account_id, NULL, 'N', 'Y') Suspense_Flag commented for 2663344
3254: FROM psp_pre_gen_dist_lines ppg,
3255: psp_organization_accounts pos,
3256: psp_payroll_controls ppc
3257: WHERE ppg.status_code = 'N'
3258: /* changed following condn. First Pass can have suspense: Bug 2007521 */
3259: AND ((ppg.gl_code_combination_id IS NULL and pos.gl_code_combination_id is null) OR

Line 3294: FROM psp_organization_accounts pos,

3290: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute8, pos.attribute8), NULL) attribute8,
3291: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute9, pos.attribute9), NULL) attribute9,
3292: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute10, pos.attribute10), NULL) attribute10
3293: ---decode(pdl.suspense_org_account_id, NULL, 'N', 'Y') Suspense_Flag uncommented for 2663344
3294: FROM psp_organization_accounts pos,
3295: psp_payroll_controls ppc,
3296: psp_payroll_lines ppl,
3297: psp_payroll_sub_lines ppsl,
3298: psp_distribution_lines pdl

Line 4348: FROM hr_all_organization_units hou, psp_organization_accounts poa

4344: WHERE ppgd.summary_line_id = p_summary_line_id;
4345:
4346: CURSOR get_susp_org_cur1 (P_ORG_ID IN VARCHAR2) IS
4347: SELECT hou.organization_id, hou.name
4348: FROM hr_all_organization_units hou, psp_organization_accounts poa
4349: WHERE hou.organization_id = poa.organization_id
4350: AND poa.business_group_id = p_business_group_id
4351: AND poa.set_of_books_id = p_set_of_books_id
4352: AND poa.organization_account_id = p_org_id;

Line 4389: FROM psp_organization_accounts poa

4385: poa.award_id,
4386: poa.task_id, -- Line added by pvelamur for bug fix 897553
4387: poa.expenditure_organization_id,
4388: poa.expenditure_type
4389: FROM psp_organization_accounts poa
4390: WHERE poa.organization_id = p_organization_id
4391: AND poa.account_type_code = 'S'
4392: AND poa.business_group_id = p_business_group_id
4393: AND poa.set_of_books_id = p_set_of_books_id

Line 4407: FROM psp_organization_accounts poa

4403: poa.award_id,
4404: poa.task_id, -- Line added by pvelamur for bugfix 897553
4405: poa.expenditure_organization_id,
4406: poa.expenditure_type
4407: FROM psp_organization_accounts poa
4408: WHERE
4409: /* poa.account_type_code = 'G'
4410: AND poa.business_group_id = p_business_group_id
4411: AND poa.set_of_books_id = p_set_of_books_id