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.PSB_WS_POS1 dependencies on PSB_WS_ACCOUNT_LINES

Line 2200: -- Account Dist records for all recurring elements (in PSB_WS_ACCOUNT_LINES)

2196: -- record
2197: -- (a) create new stage for all entries for the same SP including :
2198: -- FTE/SP record (in PSB_WS_FTE_LINES)
2199: -- Element Cost records for all recurring elements (in PSB_WS_ELEMENT_LINES)
2200: -- Account Dist records for all recurring elements (in PSB_WS_ACCOUNT_LINES)
2201: -- (b) recalculate for all recurring elements
2202:
2203: -- (ii) Change FTE only : if (start_stage_seq <> current_stage_seq) for current
2204: -- record

Line 2208: -- Account Dist records for all recurring elements (in PSB_WS_ACCOUNT_LINES)

2204: -- record
2205: -- (a) create new stage for all entries for the same SP including :
2206: -- FTE/SP record (in PSB_WS_FTE_LINES)
2207: -- Element Cost records for all recurring elements (in PSB_WS_ELEMENT_LINES)
2208: -- Account Dist records for all recurring elements (in PSB_WS_ACCOUNT_LINES)
2209: -- (b) recalculate for all recurring elements
2210:
2211: -- (iii) Change FTE and SP : if (start_stage_seq <> current_stage_seq) for current
2212: -- record

Line 2216: -- Account Dist records for all recurring elements (in PSB_WS_ACCOUNT_LINES)

2212: -- record
2213: -- (a) create new stage for all entries for the same SP including :
2214: -- FTE/SP record (in PSB_WS_FTE_LINES)
2215: -- Element Cost records for all recurring elements (in PSB_WS_ELEMENT_LINES)
2216: -- Account Dist records for all recurring elements (in PSB_WS_ACCOUNT_LINES)
2217: -- (b) recalculate for all recurring elements
2218:
2219: -- Note : Recalculation and Redistribution of Element Costs and Accounting Distributions
2220: -- are done only for recurring Elements since non-recurring Elements are by

Line 3007: from PSB_WS_ACCOUNT_LINES a,

3003: a.period45_amount, a.period46_amount, a.period47_amount, a.period48_amount,
3004: a.period49_amount, a.period50_amount, a.period51_amount, a.period52_amount,
3005: a.period53_amount, a.period54_amount, a.period55_amount, a.period56_amount,
3006: a.period57_amount, a.period58_amount, a.period59_amount, a.period60_amount
3007: from PSB_WS_ACCOUNT_LINES a,
3008: PSB_WS_ELEMENT_LINES b
3009: where a.element_set_id = b.element_set_id
3010: and p_current_stage_seq between a.start_stage_seq and a.current_stage_seq
3011: and a.stage_set_id = p_stage_set_id

Line 3058: from PSB_WS_ACCOUNT_LINES a,

3054: a.period45_amount, a.period46_amount, a.period47_amount, a.period48_amount,
3055: a.period49_amount, a.period50_amount, a.period51_amount, a.period52_amount,
3056: a.period53_amount, a.period54_amount, a.period55_amount, a.period56_amount,
3057: a.period57_amount, a.period58_amount, a.period59_amount, a.period60_amount
3058: from PSB_WS_ACCOUNT_LINES a,
3059: PSB_WS_ELEMENT_LINES b
3060: where a.element_set_id = b.element_set_id
3061: and p_current_stage_seq between a.start_stage_seq and a.current_stage_seq
3062: and a.stage_set_id = p_stage_set_id

Line 3500: -- of very first element, psb_ws_account_lines will get updated for the

3496:
3497: --
3498: -- (SRawat: Found while fixing 3140849).
3499: -- If mulitple elements correspond to same element set, during processing
3500: -- of very first element, psb_ws_account_lines will get updated for the
3501: -- element set for annual_fte. This means we need to cache annual fte
3502: -- to process rest of the elements within the same element set rather
3503: -- than reading it from psb_ws_account_lines. Note l_acct_distributed is
3504: -- always FALSE for the very first element on a per element set basis.

Line 3503: -- than reading it from psb_ws_account_lines. Note l_acct_distributed is

3499: -- If mulitple elements correspond to same element set, during processing
3500: -- of very first element, psb_ws_account_lines will get updated for the
3501: -- element set for annual_fte. This means we need to cache annual fte
3502: -- to process rest of the elements within the same element set rather
3503: -- than reading it from psb_ws_account_lines. Note l_acct_distributed is
3504: -- always FALSE for the very first element on a per element set basis.
3505: --
3506: IF NOT l_acct_distributed THEN
3507: -- Processing very first element within the set. Cache the value to be

Line 4135: from PSB_WS_ACCOUNT_LINES a

4131: a.period45_amount, a.period46_amount, a.period47_amount, a.period48_amount,
4132: a.period49_amount, a.period50_amount, a.period51_amount, a.period52_amount,
4133: a.period53_amount, a.period54_amount, a.period55_amount, a.period56_amount,
4134: a.period57_amount, a.period58_amount, a.period59_amount, a.period60_amount
4135: from PSB_WS_ACCOUNT_LINES a
4136: where exists
4137: (select 1
4138: from PSB_PAY_ELEMENTS b,
4139: PSB_WS_ELEMENT_LINES c