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.PAY_AU_RECON_SUMMARY dependencies on PAY_BALANCE_PKG

Line 42: *** 23-Mar-04 Ragovind 115.31 Bug#3525563 - Added IF condition to call pay_balance_pkg.get_value when l_max_asg_action_id is not null

38: *** 22-Nov-03 punmehta 115.27 Bug#3263659 - Modified c_asg_ids cursor to check for terminated date in last year.
39: *** 06-Feb-04 punmehta 115.28 Bug#3245909 - Modified c_get_pay_effective_date cursor to fetch Dates for only master assignment action.
40: *** 10-Feb-04 punmehta 115.29 Bug#3098367 - Added check to set a flag as 'NO' if all balances are zero.
41: *** 11-Feb-04 punmehta 115.30 Bug#3098367 - Added default value for flag.
42: *** 23-Mar-04 Ragovind 115.31 Bug#3525563 - Added IF condition to call pay_balance_pkg.get_value when l_max_asg_action_id is not null
43: *** 28-Mar-04 srrajago 115.32 Bug#3186840 - Introduced a parameter 'l_le_level' in 'populate_bal_ids' so that it can populate
44: *** defined_bal_ids of '_ASG_LE_YTD' or '_ASG_YTD' depending on the parameter value passed.
45: *** Introduced procedures 'populate_group_def_bal_ids','get_group_values_bbr',
46: *** 'get_assgt_curr_term_values_bbr' and 'get_group_assgt_values_bbr'.New procedures will be used by the

Line 175: pay_balance_pkg.get_value(def_id,

171:
172: IS
173:
174: select balance_name,
175: pay_balance_pkg.get_value(def_id,
176: c_assignment_action_id,
177: c_registered_employer,
178: null,null,null,null) balance_value
179: from

Line 276: allow_balance_value_tab pay_balance_pkg.t_balance_value_tab; /* 4863149 */

272: sum_various Number :=0;
273: counter Number := 1;
274: l_total_allowance number;
275: l_counter NUMBER;
276: allow_balance_value_tab pay_balance_pkg.t_balance_value_tab; /* 4863149 */
277: allow_context_table pay_balance_pkg.t_context_tab; /* 4863149 */
278: allow_result_table pay_balance_pkg.t_detailed_bal_out_tab; /* 4863149 */
279: i number;
280:

Line 277: allow_context_table pay_balance_pkg.t_context_tab; /* 4863149 */

273: counter Number := 1;
274: l_total_allowance number;
275: l_counter NUMBER;
276: allow_balance_value_tab pay_balance_pkg.t_balance_value_tab; /* 4863149 */
277: allow_context_table pay_balance_pkg.t_context_tab; /* 4863149 */
278: allow_result_table pay_balance_pkg.t_detailed_bal_out_tab; /* 4863149 */
279: i number;
280:
281: begin

Line 278: allow_result_table pay_balance_pkg.t_detailed_bal_out_tab; /* 4863149 */

274: l_total_allowance number;
275: l_counter NUMBER;
276: allow_balance_value_tab pay_balance_pkg.t_balance_value_tab; /* 4863149 */
277: allow_context_table pay_balance_pkg.t_context_tab; /* 4863149 */
278: allow_result_table pay_balance_pkg.t_detailed_bal_out_tab; /* 4863149 */
279: i number;
280:
281: begin
282:

Line 326: pay_balance_pkg.get_value(p_assignment_action_id => c_assignment_action_id,

322: allow_context_table(1).tax_unit_id := c_registered_employer;
323:
324: if (c_assignment_action_id is NOT NULL)
325: then
326: pay_balance_pkg.get_value(p_assignment_action_id => c_assignment_action_id,
327: p_defined_balance_lst=>allow_balance_value_tab,
328: p_context_lst =>allow_context_table,
329: p_output_table=>allow_result_table);
330:

Line 449: /* Bug#3525563 - Added IF condition to call pay_balance_pkg.get_value when l_max_asg_action_id is not null. */

445: fetch c_max_asg_action_id into l_max_asg_action_id;
446: close c_max_asg_action_id;
447: END IF;
448:
449: /* Bug#3525563 - Added IF condition to call pay_balance_pkg.get_value when l_max_asg_action_id is not null. */
450: IF l_max_asg_action_id is not null then
451: l_total_fbt := pay_balance_pkg.get_value(g_fbt_defined_balance_id,
452: l_max_asg_action_id,p_tax_unit_id, null,null,null,null);
453: ELSE

Line 451: l_total_fbt := pay_balance_pkg.get_value(g_fbt_defined_balance_id,

447: END IF;
448:
449: /* Bug#3525563 - Added IF condition to call pay_balance_pkg.get_value when l_max_asg_action_id is not null. */
450: IF l_max_asg_action_id is not null then
451: l_total_fbt := pay_balance_pkg.get_value(g_fbt_defined_balance_id,
452: l_max_asg_action_id,p_tax_unit_id, null,null,null,null);
453: ELSE
454: l_total_fbt := 0;
455: END IF;

Line 587: select pay_balance_pkg.get_value(pdb.defined_balance_id, v_assignment_action_id, c_registered_employer,null,null,null,null) --2610141

583: v_assignment_id pay_assignment_actions.assignment_id%type,
584: v_assignment_action_id pay_assignment_actions.assignment_id%type) --2610141
585:
586: IS
587: select pay_balance_pkg.get_value(pdb.defined_balance_id, v_assignment_action_id, c_registered_employer,null,null,null,null) --2610141
588: FROM pay_balance_types pbt,
589: pay_defined_balances pdb,
590: pay_balance_dimensions pbd
591: WHERE pbt.legislation_code = 'AU'

Line 1105: pay_balance_pkg.get_value(p_assignment_action_id => p_assignment_action_id,

1101: bal_id.delete;
1102: p_display_flag := 'YES';
1103: g_context_table(1).tax_unit_id := p_tax_unit_id;
1104:
1105: pay_balance_pkg.get_value(p_assignment_action_id => p_assignment_action_id,
1106: p_defined_balance_lst=>g_input_table,
1107: p_context_lst =>g_context_table,
1108: p_output_table=>g_result_table);
1109:

Line 1415: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));

1411:
1412: g_context_table(1).tax_unit_id := p_tax_unit_id;
1413:
1414: IF (g_dimension_name = '_LE_YTD') THEN
1415: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
1416: END IF;
1417:
1418: pay_balance_pkg.get_value(p_assignment_action_id => p_assignment_action_id,
1419: p_defined_balance_lst => g_input_group_details_table,

Line 1418: pay_balance_pkg.get_value(p_assignment_action_id => p_assignment_action_id,

1414: IF (g_dimension_name = '_LE_YTD') THEN
1415: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
1416: END IF;
1417:
1418: pay_balance_pkg.get_value(p_assignment_action_id => p_assignment_action_id,
1419: p_defined_balance_lst => g_input_group_details_table,
1420: p_context_lst => g_context_table,
1421: p_output_table => g_result_group_details_table);
1422:

Line 1521: pay_balance_pkg.get_value

1517: END IF;
1518: END IF;
1519: END LOOP;
1520:
1521: pay_balance_pkg.get_value
1522: ( p_assignment_action_id => p_assignment_action_id
1523: , p_defined_balance_lst => g_input_term_details_table
1524: , p_context_lst => g_context_table
1525: , p_output_table => g_result_term_details_table);

Line 1804: and pay_balance_pkg.get_value(g_fbt_defined_balance_id, rpac.assignment_action_id

1800: ,per_assignments_f paaf -- Bug: 3872211
1801: where (rppa.effective_date between p_fin_year_start and p_fin_year_end /*Bug3048962 */
1802: or ( pps.actual_termination_date between p_lst_fbt_yr_start and p_fbt_year_end /*Bug3263659 */
1803: and rppa.effective_date between p_fbt_year_start and p_fbt_year_end
1804: and pay_balance_pkg.get_value(g_fbt_defined_balance_id, rpac.assignment_action_id
1805: + decode(rppa.payroll_id, 0, 0, 0),p_legal_employer,null,null,null,null) > to_number(g_fbt_threshold))
1806: )
1807: and rppa.action_type in ('R','Q','B','I')
1808: and rpac.tax_unit_id = p_legal_employer

Line 1885: and pay_balance_pkg.get_value(g_fbt_defined_balance_id, rpac.assignment_action_id

1881: ,per_assignments_f paaf -- Bug: 3872211
1882: where (rppa.effective_date between p_fin_year_start and p_fin_year_end /*Bug3048962 */
1883: or ( pps.actual_termination_date between p_lst_fbt_yr_start and p_fbt_year_end /*Bug3263659 */
1884: and rppa.effective_date between p_fbt_year_start and p_fbt_year_end
1885: and pay_balance_pkg.get_value(g_fbt_defined_balance_id, rpac.assignment_action_id
1886: + decode(rppa.payroll_id, 0, 0, 0),p_legal_employer,null,null,null,null) > to_number(g_fbt_threshold))
1887: )
1888: and rppa.action_type in ('R','Q','B','I')
1889: and rpac.tax_unit_id = p_legal_employer

Line 1953: and pay_balance_pkg.get_value(g_fbt_defined_balance_id, rpac.assignment_action_id

1949: ,per_assignments_f paaf -- Bug: 3872211
1950: where (rppa.effective_date between p_fin_year_start and p_fin_year_end /*Bug3048962 */
1951: or ( pps.actual_termination_date between p_lst_fbt_yr_start and p_fbt_year_end /*Bug3263659 */
1952: and rppa.effective_date between p_fbt_year_start and p_fbt_year_end
1953: and pay_balance_pkg.get_value(g_fbt_defined_balance_id, rpac.assignment_action_id
1954: + decode(rppa.payroll_id, 0, 0, 0),p_legal_employer,null,null,null,null) > to_number(g_fbt_threshold) ) --2610141 /* Bug 5708255 */
1955: )
1956: and rppa.action_type in ('R','Q','B','I')
1957: and rpac.tax_unit_id = p_legal_employer