APPS.PAY_RTU_BUS dependencies on PAY_RUN_TYPE_USAGES_F

Line 29: , pay_run_type_usages_f rtu

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , pay_run_type_usages_f rtu
30: where rtu.run_type_usage_id = p_run_type_usage_id
31: and pbg.business_group_id = rtu.business_group_id;
32: --
33: -- Declare local variables

Line 89: , pay_run_type_usages_f rtu

85: --
86: cursor csr_leg_code is
87: select pbg.legislation_code
88: from per_business_groups pbg
89: , pay_run_type_usages_f rtu
90: where rtu.run_type_usage_id = p_run_type_usage_id
91: and pbg.business_group_id (+) = rtu.business_group_id;
92: --
93: -- Declare local variables

Line 499: from pay_run_type_usages_f rtu

495: --
496: CURSOR csr_usage_exists
497: is
498: select 'Y'
499: from pay_run_type_usages_f rtu
500: where rtu.parent_run_type_id = p_parent_run_type_id
501: and rtu.child_run_type_id = p_child_run_type_id
502: and p_effective_date between rtu.effective_start_date
503: and rtu.effective_end_date;

Line 773: from pay_run_type_usages_f rtu

769: --
770: CURSOR csr_chk_valid_sequence
771: is
772: select null
773: from pay_run_type_usages_f rtu
774: where rtu.parent_run_type_id = p_parent_run_type_id
775: and rtu.sequence = p_sequence
776: and p_effective_date between rtu.effective_start_date
777: and rtu.effective_end_date;