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.PER_JP_WRKREG_REPORT_PKG dependencies on PER_ASSIGNMENTS_F

Line 438: FROM per_assignments_f PAF

434: --
435: initialize(p_payroll_action_id);
436: -- Bug 8691511
437: sqlstr := ' SELECT PAA.rowid
438: FROM per_assignments_f PAF
439: ,pay_assignment_actions PAA
440: ,per_people_f PPF
441: ,hr_all_organization_units_tl HAOUT
442: ,hr_all_organization_units HAOU

Line 592: ,p_business_group_id per_assignments_f.business_group_id%TYPE

588: --************************************************************************
589: AS
590: --
591: CURSOR lcu_assact_r( p_payroll_action_id_arch pay_payroll_actions.payroll_action_id%TYPE
592: ,p_business_group_id per_assignments_f.business_group_id%TYPE
593: ,p_organization_id per_assignments_f.organization_id%TYPE
594: ,p_location_id per_assignments_f.location_id%TYPE
595: ,p_effective_date DATE
596: ,p_term_eff_date_from DATE

Line 593: ,p_organization_id per_assignments_f.organization_id%TYPE

589: AS
590: --
591: CURSOR lcu_assact_r( p_payroll_action_id_arch pay_payroll_actions.payroll_action_id%TYPE
592: ,p_business_group_id per_assignments_f.business_group_id%TYPE
593: ,p_organization_id per_assignments_f.organization_id%TYPE
594: ,p_location_id per_assignments_f.location_id%TYPE
595: ,p_effective_date DATE
596: ,p_term_eff_date_from DATE
597: ,p_term_eff_date_to DATE

Line 594: ,p_location_id per_assignments_f.location_id%TYPE

590: --
591: CURSOR lcu_assact_r( p_payroll_action_id_arch pay_payroll_actions.payroll_action_id%TYPE
592: ,p_business_group_id per_assignments_f.business_group_id%TYPE
593: ,p_organization_id per_assignments_f.organization_id%TYPE
594: ,p_location_id per_assignments_f.location_id%TYPE
595: ,p_effective_date DATE
596: ,p_term_eff_date_from DATE
597: ,p_term_eff_date_to DATE
598: ,p_include_term_flag VARCHAR2

Line 603: FROM per_assignments_f PAA

599: )
600: IS
601: SELECT PJWREV.assignment_id
602: ,PJWREV.effective_date
603: FROM per_assignments_f PAA
604: ,per_people_f PAP
605: ,pay_assignment_actions PAS
606: ,per_jp_wrkreg_emp_v PJWREV
607: ,per_periods_of_service PPOF

Line 648: ,p_business_group_id per_assignments_f.business_group_id%TYPE

644: )
645: );
646: --
647: CURSOR lcu_assact( p_payroll_action_id_arch pay_payroll_actions.payroll_action_id%TYPE
648: ,p_business_group_id per_assignments_f.business_group_id%TYPE
649: ,p_organization_id per_assignments_f.organization_id%TYPE
650: ,p_location_id per_assignments_f.location_id%TYPE
651: ,p_effective_date DATE
652: ,p_term_eff_date_from DATE

Line 649: ,p_organization_id per_assignments_f.organization_id%TYPE

645: );
646: --
647: CURSOR lcu_assact( p_payroll_action_id_arch pay_payroll_actions.payroll_action_id%TYPE
648: ,p_business_group_id per_assignments_f.business_group_id%TYPE
649: ,p_organization_id per_assignments_f.organization_id%TYPE
650: ,p_location_id per_assignments_f.location_id%TYPE
651: ,p_effective_date DATE
652: ,p_term_eff_date_from DATE
653: ,p_term_eff_date_to DATE

Line 650: ,p_location_id per_assignments_f.location_id%TYPE

646: --
647: CURSOR lcu_assact( p_payroll_action_id_arch pay_payroll_actions.payroll_action_id%TYPE
648: ,p_business_group_id per_assignments_f.business_group_id%TYPE
649: ,p_organization_id per_assignments_f.organization_id%TYPE
650: ,p_location_id per_assignments_f.location_id%TYPE
651: ,p_effective_date DATE
652: ,p_term_eff_date_from DATE
653: ,p_term_eff_date_to DATE
654: ,p_include_term_flag VARCHAR2

Line 659: FROM per_assignments_f PAA

655: )
656: IS
657: SELECT PJWREV.assignment_id
658: ,PJWREV.effective_date
659: FROM per_assignments_f PAA
660: ,per_people_f PAP
661: ,pay_assignment_actions PAS
662: ,per_jp_wrkreg_emp_v PJWREV
663: ,per_periods_of_service PPOF

Line 1200: ,start_date per_assignments_f.effective_start_date%TYPE

1196: --Added for Job History for bug 8608463
1197: TYPE job_hist_type IS RECORD(position per_positions.name%TYPE
1198: ,job per_jobs_tl.name %TYPE
1199: ,organization hr_organization_units.name%TYPE
1200: ,start_date per_assignments_f.effective_start_date%TYPE
1201: ,end_date per_assignments_f.effective_end_date%TYPE
1202: );
1203:
1204: TYPE prev_job_hist_type IS RECORD(company_name per_previous_employers.employer_name%TYPE

Line 1201: ,end_date per_assignments_f.effective_end_date%TYPE

1197: TYPE job_hist_type IS RECORD(position per_positions.name%TYPE
1198: ,job per_jobs_tl.name %TYPE
1199: ,organization hr_organization_units.name%TYPE
1200: ,start_date per_assignments_f.effective_start_date%TYPE
1201: ,end_date per_assignments_f.effective_end_date%TYPE
1202: );
1203:
1204: TYPE prev_job_hist_type IS RECORD(company_name per_previous_employers.employer_name%TYPE
1205: ,start_date per_assignments_f.effective_start_date%TYPE

Line 1205: ,start_date per_assignments_f.effective_start_date%TYPE

1201: ,end_date per_assignments_f.effective_end_date%TYPE
1202: );
1203:
1204: TYPE prev_job_hist_type IS RECORD(company_name per_previous_employers.employer_name%TYPE
1205: ,start_date per_assignments_f.effective_start_date%TYPE
1206: ,end_date per_assignments_f.effective_end_date%TYPE
1207: ,job per_jobs_tl.name %TYPE
1208: );
1209: TYPE gt_job_tbl IS TABLE of job_hist_type INDEX BY binary_integer;

Line 1206: ,end_date per_assignments_f.effective_end_date%TYPE

1202: );
1203:
1204: TYPE prev_job_hist_type IS RECORD(company_name per_previous_employers.employer_name%TYPE
1205: ,start_date per_assignments_f.effective_start_date%TYPE
1206: ,end_date per_assignments_f.effective_end_date%TYPE
1207: ,job per_jobs_tl.name %TYPE
1208: );
1209: TYPE gt_job_tbl IS TABLE of job_hist_type INDEX BY binary_integer;
1210: TYPE gt_prev_job_tbl IS TABLE of prev_job_hist_type INDEX BY binary_integer;