APPS.PAY_AU_PAYMENT_SUMMARY dependencies on STANDARD

Line 121: *** 13-Feb-04 punmehta 115.107 Bug#3132178 - Coding Standards, changed SELECT to cursor

117: *** 10-Feb-04 punmehta 115.103 Bug#3098353 - Archived a new flag which is false if all the balances are zero.
118: *** 11-Feb-04 punmehta 115.104 Bug#3098353 - Modified IF caluse for setting employee_end date.
119: *** 11-Feb-04 punmehta 115.105 Bug#3098353 - Renamed variables
120: *** 12-Feb-04 punmehta 115.106 Bug#3132178 - New procedure for calling magtape process.
121: *** 13-Feb-04 punmehta 115.107 Bug#3132178 - Coding Standards, changed SELECT to cursor
122: *** 18-Feb-04 jkarouza 115.08 Bug#3172963 - Use of BBR to retrieve balances wherever possible.
123: *** 02-Apr-04 punmehta 115.109 Bug#3549553 - Modified Union cursor and FBT cursor for balances.
124: *** 24-Apr-04 puchil 115.110 Bug#3586388 - Changed the cursor etp_code and removed gscc warnings.
125: *** 07-May-04 avenkatk 115.111 Bug#3580487 - Modified Union Cursor,removed call to hr_aubal.calc_all_balances.

Line 3110: , 'Standard_Tax_Deductions',3

3106:
3107: SELECT pdb.defined_balance_id
3108: ,decode(pbt.balance_name, 'Foreign Leave Payments',1
3109: , 'Earnings_Total',2
3110: , 'Standard_Tax_Deductions',3
3111: , 'Foreign Worker Days',4
3112: ) sort_index
3113: FROM pay_defined_balances pdb
3114: ,pay_balance_dimensions pbd

Line 3124: ,'Standard_Tax_Deductions'

3120: AND pbt.legislation_code = 'AU'
3121: AND pbt.balance_name IN (
3122: 'Foreign Leave Payments'
3123: ,'Earnings_Total'
3124: ,'Standard_Tax_Deductions'
3125: ,'Foreign Worker Days')
3126: ORDER BY sort_index;
3127:
3128: l_days NUMBER;

Line 3189: hr_utility.set_location('Standard_Tax_Deductions '||l_result_table(3).balance_value,1000);

3185: hr_utility.set_location('Start Date '||csr_rec.start_date,1000);
3186: hr_utility.set_location('End Date '||csr_rec.end_date,1000);
3187: hr_utility.set_location('Foreign Leave Payments '||l_result_table(1).balance_value,1000);
3188: hr_utility.set_location('Earnings_Total '||l_result_table(2).balance_value,1000);
3189: hr_utility.set_location('Standard_Tax_Deductions '||l_result_table(3).balance_value,1000);
3190: hr_utility.set_location('Foreign Worker Days '||l_result_table(4).balance_value,1000);
3191: END IF;
3192:
3193: l_period_days := (csr_rec.end_date - csr_rec.start_date) + 1;

Line 3200: Standard Periods

3196:
3197: IF l_result_table(1).balance_value <> 0
3198: THEN
3199: /* Foreign Leave Payments Exist. Now verify if these are for
3200: Standard Periods
3201: */
3202: IF pay_au_foreign_workers.cached = FALSE
3203: THEN
3204: pay_au_foreign_workers.populate_asg_status_id;