DBA Data[Home] [Help]

APPS.PAY_BTT_BUS dependencies on PAY_BALANCE_TYPES

Line 32: , pay_balance_types_tl btt

28: cursor csr_sec_grp is
29: select pbg.security_group_id,
30: pbg.legislation_code
31: from per_business_groups_perf pbg
32: , pay_balance_types_tl btt
33: , pay_balance_types pbt
34: where btt.balance_type_id = p_balance_type_id
35: and btt.balance_type_id = pbt.balance_type_id
36: and pbg.business_group_id = pbt.business_group_id;

Line 33: , pay_balance_types pbt

29: select pbg.security_group_id,
30: pbg.legislation_code
31: from per_business_groups_perf pbg
32: , pay_balance_types_tl btt
33: , pay_balance_types pbt
34: where btt.balance_type_id = p_balance_type_id
35: and btt.balance_type_id = pbt.balance_type_id
36: and pbg.business_group_id = pbt.business_group_id;
37: --

Line 106: , pay_balance_types_tl btt

102: --
103: cursor csr_leg_code is
104: select pbg.legislation_code
105: from per_business_groups_perf pbg
106: , pay_balance_types_tl btt
107: , pay_balance_types pbt
108: where btt.balance_type_id = p_balance_type_id
109: and btt.language = p_language
110: and btt.balance_type_id = pbt.balance_type_id

Line 107: , pay_balance_types pbt

103: cursor csr_leg_code is
104: select pbg.legislation_code
105: from per_business_groups_perf pbg
106: , pay_balance_types_tl btt
107: , pay_balance_types pbt
108: where btt.balance_type_id = p_balance_type_id
109: and btt.language = p_language
110: and btt.balance_type_id = pbt.balance_type_id
111: and pbg.business_group_id = pbt.business_group_id;