DBA Data[Home] [Help]

APPS.PAY_AU_PAYMENT_SUMMARY dependencies on DUAL

Line 200: *** 05-Oct-06 priupadh 115.174 The file is now dual maintained ,R12 version will be in Sync.

196: *** 11-Aug-06 hnainani 115.170 Bug#5395393 Modified the v_lst_year_start variable to be assigned to financial year start
197: *** instead of FBT year Start. This was done to keep it consistent with the
198: *** Archive_code procedure and End Of Year Reconciliation Reports.
199: *** 01-Sep-06 sclarke 115.172 Bug#4925547 Altered archive of allowances and unions to support 2006/2007 layout.
200: *** 05-Oct-06 priupadh 115.174 The file is now dual maintained ,R12 version will be in Sync.
201: *** 06-Oct-06 hnainani 115.179 Bug# 5377624 Modified cursor c_get_pay_Effective_date to link Time Period Id with Date_Earned
202: *** to get the assignment action id
203: ***
204: *** 10-Oct-06 abhargav 115.180 Bug#4925547 Added bug references for changes done under Bug#4925547.

Line 948: from dual;

944:
945:
946: cursor next_action_id is
947: select pay_assignment_actions_s.nextval
948: from dual;
949:
950: /* Bug 5708255 */
951: -------------------------------------------
952: -- Added cursor to get value of global FBT_THRESHOLD

Line 2532: -- they have created. This enables the identification of values for the individual unions.

2528: -- 'Union Fees' legislative balance.
2529: -- This is mandatory setup so that all existing functionality is retained.
2530: --
2531: -- The 'new' method involves users 'linking' their union elements to an additional balance
2532: -- they have created. This enables the identification of values for the individual unions.
2533: -- The 'linking' involves creating a feed to the new balance and selecting that balance
2534: -- as the 'Union fees primary balance' in the Element DF.
2535: -- This setup is not mandatory
2536: --