DBA Data[Home] [Help]

APPS.PAY_ITR_BUS dependencies on PAY_ITERATIVE_RULES_F

Line 29: , pay_iterative_rules_f itr

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , pay_iterative_rules_f itr
30: where itr.iterative_rule_id = p_iterative_rule_id
31: and pbg.business_group_id = itr.business_group_id;
32: --
33: -- Declare local variables

Line 89: , pay_iterative_rules_f itr

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

Line 270: from pay_iterative_rules_f pir

266: l_proc varchar2(72) := g_package||'chk_unique_key';
267: --
268: cursor C1 is
269: select 'Y'
270: from pay_iterative_rules_f pir
271: where pir.result_name = p_result_name
272: and pir.element_type_id = p_element_type_id
273: and pir.iterative_rule_type = p_iterative_rule_type
274: and pir.input_value_id = p_input_value_id