DBA Data[Home] [Help]

APPS.PAY_FR_SICKNESS_CALC dependencies on PAY_ELEMENT_LINKS_F

Line 2079: ,pay_element_links_f pelf

2075: paa.date_end Abs_end_date,
2076: nvl(paa.abs_information8,'N') IJSS_estimate
2077: from
2078: pay_element_entries_f peef
2079: ,pay_element_links_f pelf
2080: ,pay_element_types_f petf
2081: ,per_absence_attendances paa
2082: where peef.assignment_id = p_asg.assignment_id
2083: and peef.element_link_id = pelf.element_link_id

Line 2180: pay_element_links_f plink,

2176: --
2177: from pay_element_entry_values_f peval_pst,
2178: pay_element_entry_values_f peval_pet,
2179: pay_element_entries_f pentf,
2180: pay_element_links_f plink,
2181: pay_element_types_f peltf
2182: --
2183: where pentf.assignment_id = p_asg.assignment_id
2184: and pentf.element_link_id = plink.element_link_id

Line 3663: ,pay_element_links_f EL

3659: ,max(decode(ENT_PT.input_value_id,g_ben_balance_iv_id,ENT_PT.screen_entry_value,null)) balance
3660: from pay_element_entry_values_f ENT_PT
3661: ,pay_element_entry_values_f G
3662: ,pay_element_entries_f ENT
3663: ,pay_element_links_f EL
3664: where ENT_PT.element_entry_id = ENT.element_entry_id
3665: and G.element_entry_id = ENT.element_entry_id
3666: and G.input_value_id = g_ben_guarantee_id_iv_id
3667: and ENT.assignment_id = p_assignment_id