eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FR_PTO_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 807: from pay_element_entry_values_f pevm

803: ,sum(fnd_number.canonical_to_number(pevp.screen_entry_value))
804: ,sum(fnd_number.canonical_to_number(pevc.screen_entry_value))
805: ,sum(fnd_number.canonical_to_number(pevs.screen_entry_value))
806: ,sum(fnd_number.canonical_to_number(pevy.screen_entry_value))
807: from pay_element_entry_values_f pevm
808: ,pay_element_entry_values_f pevp
809: ,pay_element_entry_values_f pevc
810: ,pay_element_entry_values_f pevs
811: ,pay_element_entry_values_f pevy

Line 808: ,pay_element_entry_values_f pevp

804: ,sum(fnd_number.canonical_to_number(pevc.screen_entry_value))
805: ,sum(fnd_number.canonical_to_number(pevs.screen_entry_value))
806: ,sum(fnd_number.canonical_to_number(pevy.screen_entry_value))
807: from pay_element_entry_values_f pevm
808: ,pay_element_entry_values_f pevp
809: ,pay_element_entry_values_f pevc
810: ,pay_element_entry_values_f pevs
811: ,pay_element_entry_values_f pevy
812: ,pay_element_entry_values_f pevdate

Line 809: ,pay_element_entry_values_f pevc

805: ,sum(fnd_number.canonical_to_number(pevs.screen_entry_value))
806: ,sum(fnd_number.canonical_to_number(pevy.screen_entry_value))
807: from pay_element_entry_values_f pevm
808: ,pay_element_entry_values_f pevp
809: ,pay_element_entry_values_f pevc
810: ,pay_element_entry_values_f pevs
811: ,pay_element_entry_values_f pevy
812: ,pay_element_entry_values_f pevdate
813: ,pay_element_entries_f pee

Line 810: ,pay_element_entry_values_f pevs

806: ,sum(fnd_number.canonical_to_number(pevy.screen_entry_value))
807: from pay_element_entry_values_f pevm
808: ,pay_element_entry_values_f pevp
809: ,pay_element_entry_values_f pevc
810: ,pay_element_entry_values_f pevs
811: ,pay_element_entry_values_f pevy
812: ,pay_element_entry_values_f pevdate
813: ,pay_element_entries_f pee
814: where pevm.input_value_id = p_type_m_iv_id

Line 811: ,pay_element_entry_values_f pevy

807: from pay_element_entry_values_f pevm
808: ,pay_element_entry_values_f pevp
809: ,pay_element_entry_values_f pevc
810: ,pay_element_entry_values_f pevs
811: ,pay_element_entry_values_f pevy
812: ,pay_element_entry_values_f pevdate
813: ,pay_element_entries_f pee
814: where pevm.input_value_id = p_type_m_iv_id
815: and pevp.input_value_id = p_type_p_iv_id

Line 812: ,pay_element_entry_values_f pevdate

808: ,pay_element_entry_values_f pevp
809: ,pay_element_entry_values_f pevc
810: ,pay_element_entry_values_f pevs
811: ,pay_element_entry_values_f pevy
812: ,pay_element_entry_values_f pevdate
813: ,pay_element_entries_f pee
814: where pevm.input_value_id = p_type_m_iv_id
815: and pevp.input_value_id = p_type_p_iv_id
816: and pevs.input_value_id = p_type_s_iv_id

Line 835: from pay_element_entry_values_f pevm

831: cursor csr_get_ent_add(
832: p_type_m_iv_id number
833: ,p_type_accrual_date_iv_id number) is
834: select sum(pevm.screen_entry_value)
835: from pay_element_entry_values_f pevm
836: ,pay_element_entry_values_f pevdate
837: ,pay_element_entries_f pee
838: where pevm.input_value_id = p_type_m_iv_id
839: and pevdate.input_value_id = p_type_accrual_date_iv_id

Line 836: ,pay_element_entry_values_f pevdate

832: p_type_m_iv_id number
833: ,p_type_accrual_date_iv_id number) is
834: select sum(pevm.screen_entry_value)
835: from pay_element_entry_values_f pevm
836: ,pay_element_entry_values_f pevdate
837: ,pay_element_entries_f pee
838: where pevm.input_value_id = p_type_m_iv_id
839: and pevdate.input_value_id = p_type_accrual_date_iv_id
840: and pee.element_entry_id = pevm.element_entry_id

Line 3334: from pay_element_entry_values_f pevm

3330: c_type_m_iv_id number,
3331: c_type_p_iv_id number)IS
3332: select sum(pevm.screen_entry_value)
3333: ,sum(pevp.screen_entry_value)
3334: from pay_element_entry_values_f pevm
3335: ,pay_element_entry_values_f pevp
3336: ,pay_element_entry_values_f pevdate
3337: ,pay_element_entries_f pee
3338: where pevm.input_value_id = c_type_m_iv_id

Line 3335: ,pay_element_entry_values_f pevp

3331: c_type_p_iv_id number)IS
3332: select sum(pevm.screen_entry_value)
3333: ,sum(pevp.screen_entry_value)
3334: from pay_element_entry_values_f pevm
3335: ,pay_element_entry_values_f pevp
3336: ,pay_element_entry_values_f pevdate
3337: ,pay_element_entries_f pee
3338: where pevm.input_value_id = c_type_m_iv_id
3339: and pevp.input_value_id = c_type_p_iv_id

Line 3336: ,pay_element_entry_values_f pevdate

3332: select sum(pevm.screen_entry_value)
3333: ,sum(pevp.screen_entry_value)
3334: from pay_element_entry_values_f pevm
3335: ,pay_element_entry_values_f pevp
3336: ,pay_element_entry_values_f pevdate
3337: ,pay_element_entries_f pee
3338: where pevm.input_value_id = c_type_m_iv_id
3339: and pevp.input_value_id = c_type_p_iv_id
3340: and pevdate.input_value_id = c_type_accrual_date_iv_id

Line 3961: ,pay_element_entry_values_f peevM

3957: ,peevM.screen_entry_value main_rate
3958: ,peevP.screen_entry_value protected_rate
3959: from
3960: pay_element_entries_f pee
3961: ,pay_element_entry_values_f peevM
3962: ,pay_element_entry_values_f peevP
3963: where
3964: pee.element_entry_id = peevM.element_entry_id
3965: and pee.element_entry_id = peevP.element_entry_id(+)

Line 3962: ,pay_element_entry_values_f peevP

3958: ,peevP.screen_entry_value protected_rate
3959: from
3960: pay_element_entries_f pee
3961: ,pay_element_entry_values_f peevM
3962: ,pay_element_entry_values_f peevP
3963: where
3964: pee.element_entry_id = peevM.element_entry_id
3965: and pee.element_entry_id = peevP.element_entry_id(+)
3966: and pee.element_link_id in (select element_link_id

Line 4114: from pay_element_entry_values_f pevd

4110: l_proc VARCHAR2(72) := g_package||' get_fr_latest_ent_date ';
4111: --
4112: CURSOR csr_latest_ent_date (p_ent_accrual_date_iv_id in number, p_Accrual_start_date in date, p_accrual_end_date in date) is
4113: select max(pee.effective_end_Date)
4114: from pay_element_entry_values_f pevd
4115: ,pay_element_entries_f pee
4116: where pevd.input_value_id = p_ent_accrual_date_iv_id
4117: and pee.element_entry_id = pevd.element_entry_id
4118: and pevd.screen_entry_value between fnd_date.date_to_canonical(p_accrual_start_date)

Line 4185: from pay_element_entry_values_f pevn

4181: --
4182: CURSOR csr_ref_entitlement (p_sal_input_id in number,p_day_input_id in number,p_date_input_id in number) is
4183: select sum(fnd_number.canonical_to_number(pevn.screen_entry_value)),
4184: sum(fnd_number.canonical_to_number(pevs.screen_entry_value))
4185: from pay_element_entry_values_f pevn
4186: ,pay_element_entry_values_f pevd
4187: ,pay_element_entry_values_f pevs
4188: ,pay_element_entries_f pee
4189: where pevn.input_value_id = p_day_input_id

Line 4186: ,pay_element_entry_values_f pevd

4182: CURSOR csr_ref_entitlement (p_sal_input_id in number,p_day_input_id in number,p_date_input_id in number) is
4183: select sum(fnd_number.canonical_to_number(pevn.screen_entry_value)),
4184: sum(fnd_number.canonical_to_number(pevs.screen_entry_value))
4185: from pay_element_entry_values_f pevn
4186: ,pay_element_entry_values_f pevd
4187: ,pay_element_entry_values_f pevs
4188: ,pay_element_entries_f pee
4189: where pevn.input_value_id = p_day_input_id
4190: and pevd.input_value_id = p_date_input_id

Line 4187: ,pay_element_entry_values_f pevs

4183: select sum(fnd_number.canonical_to_number(pevn.screen_entry_value)),
4184: sum(fnd_number.canonical_to_number(pevs.screen_entry_value))
4185: from pay_element_entry_values_f pevn
4186: ,pay_element_entry_values_f pevd
4187: ,pay_element_entry_values_f pevs
4188: ,pay_element_entries_f pee
4189: where pevn.input_value_id = p_day_input_id
4190: and pevd.input_value_id = p_date_input_id
4191: and pevs.input_value_id = p_sal_input_id

Line 5746: ,pay_element_entry_values_f pev_ref

5742: l_value_defaulted number(1);
5743: cursor csr_find_entry is
5744: select 0, pev_def.screen_entry_value
5745: from pay_element_entries_f pee
5746: ,pay_element_entry_values_f pev_ref
5747: ,pay_input_values_f piv_ref
5748: ,pay_element_types_f pet
5749: ,pay_input_values_f piv_def
5750: ,pay_element_entry_values_f pev_def

Line 5750: ,pay_element_entry_values_f pev_def

5746: ,pay_element_entry_values_f pev_ref
5747: ,pay_input_values_f piv_ref
5748: ,pay_element_types_f pet
5749: ,pay_input_values_f piv_def
5750: ,pay_element_entry_values_f pev_def
5751: where pet.element_name = 'FR_FIXED_TERM_CONTRACT_INDEMNITY'
5752: and pet.legislation_code = 'FR'
5753: and pet.business_group_id is null
5754: and pet.element_type_id = piv_ref.element_type_id

Line 6001: from pay_element_entry_values_f pevm

5997: c_type_m_iv_id number
5998: ,c_start_date date
5999: ,c_end_date date) is
6000: select nvl(sum(pevm.screen_entry_value),0)
6001: from pay_element_entry_values_f pevm
6002: ,pay_element_entries_f pee
6003: ,per_all_assignments_f pasg
6004: where pevm.input_value_id = c_type_m_iv_id
6005: and pee.element_entry_id = pevm.element_entry_id