APPS.PAY_US_USER_INIT_DEDN dependencies on PAY_DEFINED_BALANCES

Line 1942: update pay_defined_balances

1938: loop
1939: l_asg_gre_run_dim_id := crec.balance_dimension_id;
1940: end loop;
1941:
1942: update pay_defined_balances
1943: set save_run_balance = 'Y'
1944: where balance_type_id = l_pri_bal_id
1945: and balance_dimension_id = l_asg_gre_run_dim_id
1946: and business_group_id = p_bg_id;

Line 1963: update pay_defined_balances

1959: element_information19 = l_at_sf_core_element_type_id
1960: where element_type_id = l_at_base_element_type_id
1961: and business_group_id = p_bg_id;
1962:
1963: update pay_defined_balances
1964: set save_run_balance = 'Y'
1965: where balance_type_id = l_at_pri_bal_id
1966: and balance_dimension_id = l_asg_gre_run_dim_id
1967: and business_group_id = p_bg_id;

Line 1985: update pay_defined_balances

1981: element_information19 = l_roth_sf_ele_type_id
1982: where element_type_id = l_roth_ele_type_id
1983: and business_group_id = p_bg_id;
1984:
1985: update pay_defined_balances
1986: set save_run_balance = 'Y'
1987: where balance_type_id = l_atr_pri_bal_id
1988: and balance_dimension_id = l_asg_gre_run_dim_id
1989: and business_group_id = p_bg_id;

Line 1999: update pay_defined_balances

1995: element_information_category = 'US_EMPLOYER LIABILITIES'
1996: where element_type_id = l_roth_er_ele_type_id
1997: and business_group_id = p_bg_id;
1998:
1999: update pay_defined_balances
2000: set save_run_balance = 'Y'
2001: where balance_type_id = l_atr_er_bal_id
2002: and balance_dimension_id = l_asg_gre_run_dim_id
2003: and business_group_id = p_bg_id;

Line 2028: update pay_defined_balances

2024: where element_type_id = l_cu_element_type_id
2025: and business_group_id = p_bg_id;
2026:
2027: insert_iterative_rules(l_cu_element_type_id);
2028: update pay_defined_balances
2029: set save_run_balance = 'Y'
2030: where balance_type_id = l_cu_pri_bal_id
2031: and balance_dimension_id = l_asg_gre_run_dim_id
2032: and business_group_id = p_bg_id;

Line 2055: update pay_defined_balances

2051: and business_group_id = p_bg_id;
2052:
2053: insert_iterative_rules(l_bb_element_type_id);
2054:
2055: update pay_defined_balances
2056: set save_run_balance = 'Y'
2057: where balance_type_id = l_bb_pri_bal_id
2058: and balance_dimension_id = l_asg_gre_run_dim_id
2059: and business_group_id = p_bg_id;

Line 2133: update pay_defined_balances

2129: where element_type_id = l_at_er_element_type_id
2130: and business_group_id = p_bg_id;
2131: end if;
2132: --
2133: update pay_defined_balances
2134: set save_run_balance = 'Y'
2135: where balance_type_id = l_er_bal_id
2136: and balance_dimension_id = l_asg_gre_run_dim_id
2137: and business_group_id = p_bg_id;

Line 2139: update pay_defined_balances

2135: where balance_type_id = l_er_bal_id
2136: and balance_dimension_id = l_asg_gre_run_dim_id
2137: and business_group_id = p_bg_id;
2138:
2139: update pay_defined_balances
2140: set save_run_balance = 'Y'
2141: where balance_type_id = l_at_er_bal_id
2142: and balance_dimension_id = l_asg_gre_run_dim_id
2143: and business_group_id = p_bg_id;