DBA Data[Home] [Help]

APPS.PAY_IN_TERM_RPRT_GEN_PKG dependencies on PAY_BALANCE_TYPES

Line 916: ,pay_balance_types pbt

912: ,'Leave Encashment'
913: ,'Other Termination Payments')
914: AND pet.element_name NOT IN (select petf.element_name
915: from pay_balance_feeds_f pbff
916: ,pay_balance_types pbt
917: ,pay_input_values_f pivf
918: ,pay_element_types_f petf
919: where pbff.balance_type_id = pbt.balance_type_id
920: and pbt.balance_name in ('Retrenchment Compensation'

Line 996: ,pay_balance_types pbt

992: FROM per_assignments_f paf
993: ,per_people_f ppf
994: ,pay_assignment_actions paa
995: ,per_periods_of_service ppos
996: ,pay_balance_types pbt
997: ,pay_balance_dimensions pbd
998: ,pay_defined_balances pdb
999: WHERE paf.business_group_id = p_bus_grp_id
1000: AND ppf.employee_number = p_employee_number

Line 1075: ,pay_balance_types pbt

1071: FROM per_assignments_f paf
1072: ,per_people_f ppf
1073: ,pay_assignment_actions paa
1074: ,per_periods_of_service ppos
1075: ,pay_balance_types pbt
1076: ,pay_balance_dimensions pbd
1077: ,pay_defined_balances pdb
1078: WHERE paf.business_group_id = p_bus_grp_id
1079: AND ppf.employee_number = p_employee_number