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 630: psp_organization_accounts pod,

626: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute9, pos.attribute9), NULL) attribute9,
627: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute10, pos.attribute10), NULL) attribute10
628: ---decode(pdl.suspense_org_account_id, NULL, 'N', 'Y') Suspense_Flag commented for 2663344
629: FROM psp_schedule_lines psl,
630: psp_organization_accounts pod,
631: psp_organization_accounts pos,
632: psp_element_type_accounts pea,
633: psp_default_labor_schedules pdls,
634: psp_payroll_controls ppc,

Line 631: psp_organization_accounts pos,

627: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute10, pos.attribute10), NULL) attribute10
628: ---decode(pdl.suspense_org_account_id, NULL, 'N', 'Y') Suspense_Flag commented for 2663344
629: FROM psp_schedule_lines psl,
630: psp_organization_accounts pod,
631: psp_organization_accounts pos,
632: psp_element_type_accounts pea,
633: psp_default_labor_schedules pdls,
634: psp_payroll_controls ppc,
635: psp_payroll_lines ppl,

Line 680: psp_organization_accounts pos,

676: DECODE(g_dff_grouping_option, 'Y', DECODE(ppg.suspense_org_account_id, NULL, ppg.attribute9, pos.attribute9), NULL) attribute9,
677: DECODE(g_dff_grouping_option, 'Y', DECODE(ppg.suspense_org_account_id, NULL, ppg.attribute10, pos.attribute10), NULL) attribute10
678: ---decode(ppg.suspense_org_Account_id, NULL, 'N', 'Y') Suspense_Flag commented for 2663344
679: FROM psp_pre_gen_dist_lines ppg,
680: psp_organization_accounts pos,
681: psp_payroll_controls ppc
682: WHERE ppg.status_code = 'N'
683: /* changed following condition for bug 2007521 */
684: AND ((ppg.gl_code_combination_id IS NOT NULL and pos.project_id is null)

Line 719: psp_organization_accounts pos,

715: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute10, pos.attribute10), NULL) attribute10
716: FROM psp_payroll_controls ppc,
717: psp_payroll_lines ppl,
718: psp_payroll_sub_lines ppsl,
719: psp_organization_accounts pos,
720: psp_distribution_lines pdl
721: WHERE pdl.status_code = 'N'
722: AND pdl.payroll_sub_line_id = ppsl.payroll_sub_line_id
723: AND ppsl.payroll_line_id = ppl.payroll_line_id

Line 1744: FROM hr_all_organization_units hou, psp_organization_accounts poa

1740: -- Get the Organization details ...
1741:
1742: CURSOR get_susp_org_cur(P_ORG_ID IN VARCHAR2) IS
1743: SELECT hou.organization_id, hou.name, poa.gl_code_combination_id
1744: FROM hr_all_organization_units hou, psp_organization_accounts poa
1745: WHERE hou.organization_id = poa.organization_id
1746: AND poa.business_group_id = p_business_group_id
1747: AND poa.set_of_books_id = p_set_of_books_id
1748: AND poa.organization_account_id = p_org_id;

Line 1789: FROM psp_organization_accounts poa

1785: poa.award_id,
1786: poa.task_id,
1787: poa.expenditure_organization_id,
1788: poa.expenditure_type
1789: FROM psp_organization_accounts poa
1790: WHERE poa.organization_id = p_organization_id
1791: AND poa.account_type_code = 'S'
1792: AND poa.business_group_id = p_business_group_id
1793: AND poa.set_of_books_id = p_set_of_books_id

Line 1807: FROM psp_organization_accounts poa

1803: poa.award_id,
1804: poa.task_id,
1805: poa.expenditure_organization_id,
1806: poa.expenditure_type
1807: FROM psp_organization_accounts poa
1808: WHERE
1809: /* poa.account_type_code = 'G'
1810: AND poa.business_group_id = p_business_group_id
1811: AND poa.set_of_books_id = p_set_of_books_id

Line 2596: psp_organization_accounts pos

2592: ppgd.set_of_books_id,
2593: ppgd.business_group_id,
2594: round(sum(ppgd.distribution_amount), p_precision) reversal_dist_amount -- For Bug 2916848 changed to p_precision
2595: FROM psp_pre_gen_dist_lines ppgd,
2596: psp_organization_accounts pos
2597: WHERE ppgd.payroll_control_id = p_payroll_control_id
2598: AND nvl(ppgd.reversal_entry_flag,'N') = 'N'
2599: AND ((ppgd.gl_code_combination_id IS NOT NULL and pos.project_id is null ) OR -- Bug 2007521 Changed condn
2600: pos.gl_code_combination_id IS NOT NULL)

Line 2737: from psp_pre_gen_dist_lines ppgd, psp_organization_accounts pos

2733:
2734: select sum(decode(reversal_entry_flag, 'Y', distribution_amount, 0)),
2735: sum(decode(reversal_entry_flag, 'Y', 0, distribution_amount))
2736: into l_cr_amount, l_dr_amount
2737: from psp_pre_gen_dist_lines ppgd, psp_organization_accounts pos
2738: where payroll_control_id = p_payroll_control_id
2739: and ppgd.status_code = 'N'
2740: and ppgd.suspense_org_account_id = pos.organization_account_id(+)
2741: AND ((ppgd.gl_code_combination_id IS NOT NULL and ppgd.suspense_org_account_id is null ) OR

Line 3016: psp_organization_accounts pod,

3012: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute9, pos.attribute9), NULL) attribute9,
3013: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute10, pos.attribute10), NULL) attribute10
3014: ---decode(pdl.suspense_org_account_id, NULL, 'N', 'Y') Suspense_Flag uncommented for 2663344
3015: FROM psp_schedule_lines psl,
3016: psp_organization_accounts pod,
3017: psp_organization_accounts pos,
3018: psp_element_type_accounts pea,
3019: psp_default_labor_schedules pdls,
3020: psp_payroll_controls ppc,

Line 3017: psp_organization_accounts pos,

3013: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute10, pos.attribute10), NULL) attribute10
3014: ---decode(pdl.suspense_org_account_id, NULL, 'N', 'Y') Suspense_Flag uncommented for 2663344
3015: FROM psp_schedule_lines psl,
3016: psp_organization_accounts pod,
3017: psp_organization_accounts pos,
3018: psp_element_type_accounts pea,
3019: psp_default_labor_schedules pdls,
3020: psp_payroll_controls ppc,
3021: psp_payroll_lines ppl,

Line 3073: psp_organization_accounts pos,

3069: DECODE(g_dff_grouping_option, 'Y', DECODE(ppg.suspense_org_account_id, NULL, ppg.attribute9, pos.attribute9), NULL) attribute9,
3070: DECODE(g_dff_grouping_option, 'Y', DECODE(ppg.suspense_org_account_id, NULL, ppg.attribute10, pos.attribute10), NULL) attribute10
3071: ---decode(ppg.suspense_org_Account_id, NULL, 'N', 'Y') Suspense_Flag commented for 2663344
3072: FROM psp_pre_gen_dist_lines ppg,
3073: psp_organization_accounts pos,
3074: psp_payroll_controls ppc
3075: WHERE ppg.status_code = 'N'
3076: /* changed following condn. First Pass can have suspense: Bug 2007521 */
3077: AND ((ppg.gl_code_combination_id IS NULL and pos.gl_code_combination_id is null) OR

Line 3112: FROM psp_organization_accounts pos,

3108: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute8, pos.attribute8), NULL) attribute8,
3109: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute9, pos.attribute9), NULL) attribute9,
3110: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute10, pos.attribute10), NULL) attribute10
3111: ---decode(pdl.suspense_org_account_id, NULL, 'N', 'Y') Suspense_Flag uncommented for 2663344
3112: FROM psp_organization_accounts pos,
3113: psp_payroll_controls ppc,
3114: psp_payroll_lines ppl,
3115: psp_payroll_sub_lines ppsl,
3116: psp_distribution_lines pdl

Line 4085: FROM hr_all_organization_units hou, psp_organization_accounts poa

4081: WHERE ppgd.summary_line_id = p_summary_line_id;
4082:
4083: CURSOR get_susp_org_cur1 (P_ORG_ID IN VARCHAR2) IS
4084: SELECT hou.organization_id, hou.name
4085: FROM hr_all_organization_units hou, psp_organization_accounts poa
4086: WHERE hou.organization_id = poa.organization_id
4087: AND poa.business_group_id = p_business_group_id
4088: AND poa.set_of_books_id = p_set_of_books_id
4089: AND poa.organization_account_id = p_org_id;

Line 4126: FROM psp_organization_accounts poa

4122: poa.award_id,
4123: poa.task_id, -- Line added by pvelamur for bug fix 897553
4124: poa.expenditure_organization_id,
4125: poa.expenditure_type
4126: FROM psp_organization_accounts poa
4127: WHERE poa.organization_id = p_organization_id
4128: AND poa.account_type_code = 'S'
4129: AND poa.business_group_id = p_business_group_id
4130: AND poa.set_of_books_id = p_set_of_books_id

Line 4144: FROM psp_organization_accounts poa

4140: poa.award_id,
4141: poa.task_id, -- Line added by pvelamur for bugfix 897553
4142: poa.expenditure_organization_id,
4143: poa.expenditure_type
4144: FROM psp_organization_accounts poa
4145: WHERE
4146: /* poa.account_type_code = 'G'
4147: AND poa.business_group_id = p_business_group_id
4148: AND poa.set_of_books_id = p_set_of_books_id