DBA Data[Home] [Help]

APPS.PAY_US_USER_INIT_DEDN dependencies on PAY_DEFINED_BALANCES

Line 1939: update pay_defined_balances

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

Line 1960: update pay_defined_balances

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

Line 1982: update pay_defined_balances

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

Line 1996: update pay_defined_balances

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

Line 2025: update pay_defined_balances

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

Line 2052: update pay_defined_balances

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

Line 2130: update pay_defined_balances

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

Line 2136: update pay_defined_balances

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