DBA Data[Home] [Help]

APPS.PAY_DK_SICKNESS_DP201 dependencies on PAY_BALANCE_TYPES

Line 25: ,pay_balance_types pbt

21: INTO
22: l_defined_balance_id
23: FROM
24: pay_defined_balances pdb
25: ,pay_balance_types pbt
26: ,pay_balance_dimensions pbd
27: WHERE
28: pbd.database_item_suffix = p_dbi_suffix
29: AND (pbd.legislation_code = 'DK' OR pbt.business_group_id = p_business_group_id)

Line 97: pay_balance_types pbt

93: ,asg_act_id)) - pay_balance_pkg.get_value(
94: get_defined_balance_id('Employee AMB Deduction','_ASG_PTD',p_business_group_id)
95: ,asg_act_id) pay_value
96: FROM
97: pay_balance_types pbt
98: ,pay_balance_categories_f pbcf
99: WHERE
100: pbcf.legislation_code = 'DK'
101: AND pbcf.category_name = 'Salary Reporting'