DBA Data[Home] [Help]

APPS.PAY_HK_IR56 dependencies on PAY_ELEMENT_TYPES_F

Line 79: l_processing_type pay_element_types_f.processing_type%TYPE;

75: l_start_date DATE;
76: l_end_date DATE;
77: l_fin_start_date DATE;
78: l_fin_end_date DATE;
79: l_processing_type pay_element_types_f.processing_type%TYPE;
80: l_particulars hr_lookups.description%TYPE;
81: l_hire_date per_periods_of_service.date_start%TYPE;
82: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
83: i NUMBER := 1;

Line 93: FROM pay_element_types_f pet,

89: IS
90: SELECT min(pee.effective_start_date),
91: max(pee.effective_end_date),
92: min(pet.processing_type)
93: FROM pay_element_types_f pet,
94: pay_element_entries_f pee,
95: pay_element_links_f pel,
96: pay_balance_types pbt,
97: pay_balance_feeds_f pbf,