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.

[Home] [Help]

APPS.PAY_CA_PAYREG_EXTRACT_PKG dependencies on PER_ALL_PEOPLE_F

Line 700: from per_all_people_f ppf

696: ,paa_key.assignment_action_id
697: ,paa_key.date_earned
698: ,paa_key.effective_date /* BUG: 5383895 paa_key.date_earned changed to paa_key.effective_date */
699: ,popm.defined_balance_id /* BUG: 5383895 added to avoid the cursor c_tp_pmt_check */
700: from per_all_people_f ppf
701: ,per_all_assignments_f paf
702: ,hr_all_organization_units_tl hou
703: ,pay_all_payrolls_f pap
704: ,pay_payment_types_tl ppt_tl

Line 911: from per_all_people_f ppf

907: /* Query to get the payee_name for payee_type 'P'
908: Added this curosr to fix bug#2745577 */
909: cursor c_payee_full_name (cp_payee_id number,cp_effective_date date) IS /* BUG: 5383895 cp_date_earned changed to cp_effective_date */
910: select initcap(rtrim(ppf.title))||' '||rtrim(ppf.first_name)||' '||rtrim(ppf.last_name)
911: from per_all_people_f ppf
912: where ppf.person_id = cp_payee_id
913: and cp_effective_date between ppf.effective_start_date and
914: ppf.effective_end_date; /* BUG: 5383895 cp_date_earned changed to cp_effective_date */
915: