APPS.PAY_ITERATE dependencies on PAY_RUN_TYPE_USAGES_F

Line 911: from pay_run_type_usages_f

907: , object_version_number
908: , business_group_id
909: , legislation_code
910: , effective_start_date
911: from pay_run_type_usages_f
912: where parent_run_type_id = l_rt_id;
913: --
914: cursor chk_for_tl_children
915: is

Line 1219: from pay_run_type_usages_f

1215: select run_type_usage_id
1216: , object_version_number
1217: , business_group_id
1218: , legislation_code
1219: from pay_run_type_usages_f
1220: where parent_run_type_id = rec_uploaded.rt_id
1221: and effective_end_date >= g_to_be_uploaded_eed;
1222: --
1223: cursor chk_for_tl_children

Line 1977: from pay_run_type_usages_f

1973: , business_group_id
1974: , effective_start_date
1975: , effective_end_date
1976: , object_version_number
1977: from pay_run_type_usages_f
1978: where parent_run_type_id = p_parent_rt_id
1979: and child_run_type_id = p_child_rt_id
1980: and business_group_id = (select pbg.business_group_id
1981: from per_business_groups pbg

Line 1997: from pay_run_type_usages_f

1993: , business_group_id
1994: , effective_start_date
1995: , effective_end_date
1996: , object_version_number
1997: from pay_run_type_usages_f
1998: where parent_run_type_id = p_parent_rt_id
1999: and child_run_type_id = p_child_rt_id
2000: and legislation_code = p_legislation_code
2001: and business_group_id is null;

Line 2015: from pay_run_type_usages_f

2011: , business_group_id
2012: , effective_start_date
2013: , effective_end_date
2014: , object_version_number
2015: from pay_run_type_usages_f
2016: where parent_run_type_id = p_parent_rt_id
2017: and child_run_type_id = p_child_rt_id
2018: and business_group_id is null
2019: and legislation_code is null;

Line 2064: from pay_run_type_usages_f

2060: ,p_sequence_num number
2061: ,p_eff_st_date date)
2062: is
2063: select run_type_usage_id
2064: from pay_run_type_usages_f
2065: where parent_run_type_id = p_par_id
2066: and sequence = p_sequence_num
2067: and p_eff_st_date between effective_start_date
2068: and effective_end_date;

Line 2130: from pay_run_type_usages_f

2126: , effective_end_date
2127: , object_version_number
2128: , l_mode
2129: into rec_rtu_uploaded
2130: from pay_run_type_usages_f
2131: where run_type_usage_id = l_out_rtu_id;
2132: --
2133: end insert_row;
2134: -------------------------------------------

Line 2163: delete from pay_run_type_usages_f

2159: hr_utility.trace('eff start date: '||to_char(p_effective_start_date,'dd-mon-yyyy'));
2160: --
2161: -- use delete rather than api delete to bypass validation
2162: --
2163: delete from pay_run_type_usages_f
2164: where run_type_usage_id = p_rtu_id;
2165: --
2166: if l_valid_seq <> 0 then
2167: --

Line 2168: delete from pay_run_type_usages_f

2164: where run_type_usage_id = p_rtu_id;
2165: --
2166: if l_valid_seq <> 0 then
2167: --
2168: delete from pay_run_type_usages_f
2169: where run_type_usage_id = l_valid_seq;
2170: end if;
2171: --
2172: pay_run_type_usage_api.create_run_type_usage

Line 2200: from pay_run_type_usages_f

2196: , effective_end_date
2197: , object_version_number
2198: , l_mode
2199: into rec_rtu_uploaded
2200: from pay_run_type_usages_f
2201: where run_type_usage_id = l_out_rtu_id;
2202: --
2203: end zap_insert;
2204: -------------------------------------------

Line 2249: from pay_run_type_usages_f

2245: , effective_end_date
2246: , object_version_number
2247: , l_mode
2248: into rec_rtu_uploaded
2249: from pay_run_type_usages_f
2250: where run_type_usage_id = rec_rtu_uploaded.rtu_id
2251: and effective_start_date = l_out_esd
2252: and effective_end_date = l_out_eed;
2253: --

Line 3250: , pay_run_type_usages_f rtu

3246: is
3247: select prt.run_type_name
3248: , prt.run_method
3249: from pay_run_types_f prt
3250: , pay_run_type_usages_f rtu
3251: where prt.run_method = 'C'
3252: and nvl(prt.legislation_code, 'NULL') = nvl(p_leg_code, 'NULL')
3253: and nvl(prt.business_group_id, -1) = nvl(p_bg, -1)
3254: and prt.run_type_name = p_rt_name