APPS.PAY_AU_PAYMENT_SUMMARY dependencies on PAY_BALANCE_ATTRIBUTES

Line 295: g_attribute_id pay_balance_attributes.attribute_id%type; -- bug 7571001

291: g_legislation_code constant varchar2(2) := 'AU';
292: g_dimension_id pay_balance_dimensions.balance_dimension_id%type;
293: g_balance_type_id pay_balance_types.balance_type_id%type; /*Bug#5591993*/
294: g_fbt_threshold ff_globals_f.global_value%TYPE ; /* Bug 5708255 */
295: g_attribute_id pay_balance_attributes.attribute_id%type; -- bug 7571001
296: g_termination_type varchar2(4); /*Bug#8315198 - Variable to store the termination type*/
297: --
298: /*
299: ** 4177679 this new flag would be Y when the etp employee date has to be archived

Line 730: FROM pay_balance_attributes pba

726:
727: cursor c_get_fw_alw_bal_type_id is
728: SELECT pbt.balance_type_id,
729: pbt.balance_name
730: FROM pay_balance_attributes pba
731: ,pay_defined_balances pdb
732: ,pay_balance_types pbt
733: ,pay_balance_dimensions pbd
734: WHERE pba.attribute_id = g_attribute_id

Line 2725: , PAY_BALANCE_ATTRIBUTES pba

2721: ,pay_run_results prr
2722: ,pay_element_types_f pet
2723: /* below added for bug 7571001 */
2724: ,PAY_BAL_ATTRIBUTE_DEFINITIONS pbad
2725: , PAY_BALANCE_ATTRIBUTES pba
2726: ,pay_defined_balances pdb
2727: ,pay_balance_dimensions pbd
2728: ,PAY_BALANCE_FEEDS_F pbf
2729: ,pay_input_values_f piv

Line 4209: FROM pay_balance_attributes pba

4205: ,pay_balance_pkg.get_value(pdb.defined_balance_id
4206: ,p_max_assignment_action_id
4207: ,p_registered_employer
4208: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL) balance_value
4209: FROM pay_balance_attributes pba
4210: ,pay_defined_balances pdb
4211: ,pay_balance_types pbt
4212: ,pay_balance_dimensions pbd
4213: WHERE pba.attribute_id = g_attribute_id