DBA Data[Home] [Help]

APPS.PAY_IN_TERM_RPRT_GEN_PKG dependencies on PAY_BALANCE_TYPES

Line 819: ,pay_balance_types pbt

815: ,'Leave Encashment'
816: ,'Other Termination Payments')
817: AND pet.element_name NOT IN (select petf.element_name
818: from pay_balance_feeds_f pbff
819: ,pay_balance_types pbt
820: ,pay_input_values_f pivf
821: ,pay_element_types_f petf
822: where pbff.balance_type_id = pbt.balance_type_id
823: and pbt.balance_name in ('Retrenchment Compensation'

Line 899: ,pay_balance_types pbt

895: FROM per_assignments_f paf
896: ,per_people_f ppf
897: ,pay_assignment_actions paa
898: ,per_periods_of_service ppos
899: ,pay_balance_types pbt
900: ,pay_balance_dimensions pbd
901: ,pay_defined_balances pdb
902: WHERE paf.business_group_id = p_bus_grp_id
903: AND ppf.employee_number = p_employee_number

Line 978: ,pay_balance_types pbt

974: FROM per_assignments_f paf
975: ,per_people_f ppf
976: ,pay_assignment_actions paa
977: ,per_periods_of_service ppos
978: ,pay_balance_types pbt
979: ,pay_balance_dimensions pbd
980: ,pay_defined_balances pdb
981: WHERE paf.business_group_id = p_bus_grp_id
982: AND ppf.employee_number = p_employee_number