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_CN_AUDIT_XMLGEN dependencies on PER_ALL_ASSIGNMENTS_F

Line 600: from per_all_assignments_f paf,

596: to_number(TO_CHAR(ppa.effective_date,'MM')) pno,
597: to_CHAR(decode(g_trfr_date_used,'E',ppa.date_earned,ppa.effective_date) ,'YYYY') acct_yr,
598: to_number(to_CHAR(decode(g_trfr_date_used,'E',ppa.date_earned,ppa.effective_date) ,'MM')) accnt_prd,
599: 'CNY' currency
600: from per_all_assignments_f paf,
601: pay_payroll_actions ppa,
602: pay_assignment_actions paa
603: where ppa.effective_date between paf.effective_start_date and paf.effective_end_date
604: and paf.assignment_id = p_assignment_id

Line 885: per_all_assignments_f paf

881: where pap.payroll_id = p_payroll_id
882: AND g_end_date BETWEEN pap.effective_start_date AND pap.effective_end_date) pname,
883: (SELECT ppf.employee_number
884: FROM per_all_people_f ppf,
885: per_all_assignments_f paf
886: WHERE paf.person_id = ppf.person_id
887: AND paf.assignment_id = p_assignment_id
888: AND p_date_earned BETWEEN ppf.effective_start_date and ppf.effective_end_date
889: AND p_date_earned BETWEEN paf.effective_start_date and paf.effective_end_date) person,

Line 927: per_all_assignments_f paf

923: where pap.payroll_id = p_payroll_id
924: AND g_end_date BETWEEN pap.effective_start_date AND pap.effective_end_date) pname,
925: (SELECT ppf.employee_number
926: FROM per_all_people_f ppf,
927: per_all_assignments_f paf
928: WHERE paf.person_id = ppf.person_id
929: AND paf.assignment_id = p_assignment_id
930: AND p_date_earned BETWEEN ppf.effective_start_date and ppf.effective_end_date
931: AND p_date_earned BETWEEN paf.effective_start_date and paf.effective_end_date) person,

Line 978: per_all_assignments_f paf

974: where pap.payroll_id = p_payroll_id
975: AND g_end_date BETWEEN pap.effective_start_date AND pap.effective_end_date) pname,
976: (SELECT ppf.employee_number
977: FROM per_all_people_f ppf,
978: per_all_assignments_f paf
979: WHERE paf.person_id = ppf.person_id
980: AND paf.assignment_id = p_assignment_id
981: AND p_date_earned BETWEEN ppf.effective_start_date and ppf.effective_end_date
982: AND p_date_earned BETWEEN paf.effective_start_date and paf.effective_end_date) person,