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_EMPDET_REPORT_PKG dependencies on PER_ASSIGNMENTS_F

Line 596: FROM per_assignments_f PAF

592: --
593: initialize(p_payroll_action_id);
594:
595: sqlstr := ' SELECT PAA.rowid
596: FROM per_assignments_f PAF
597: ,pay_assignment_actions PAA
598: ,per_people_f PPF
599: ,hr_all_organization_units HAOU
600: ,per_periods_of_service PPS

Line 690: FROM per_assignments_f PAF

686: --
687: initialize(p_payroll_action_id);
688:
689: sqlstr := ' SELECT PAA.rowid
690: FROM per_assignments_f PAF
691: ,pay_assignment_actions PAA
692: ,per_people_f PPF
693: ,hr_all_organization_units_tl HAOUT
694: ,hr_all_organization_units HAOU

Line 835: , p_business_group_id per_assignments_f.business_group_id%TYPE

831: --************************************************************************
832: AS
833: --
834: CURSOR lcu_assact_r( p_payroll_action_id_arch pay_payroll_actions.payroll_action_id%TYPE
835: , p_business_group_id per_assignments_f.business_group_id%TYPE
836: , p_organization_id per_assignments_f.organization_id%TYPE
837: , p_location_id per_assignments_f.location_id%TYPE
838: , p_include_term_flag VARCHAR2
839: , p_term_eff_date_from DATE

Line 836: , p_organization_id per_assignments_f.organization_id%TYPE

832: AS
833: --
834: CURSOR lcu_assact_r( p_payroll_action_id_arch pay_payroll_actions.payroll_action_id%TYPE
835: , p_business_group_id per_assignments_f.business_group_id%TYPE
836: , p_organization_id per_assignments_f.organization_id%TYPE
837: , p_location_id per_assignments_f.location_id%TYPE
838: , p_include_term_flag VARCHAR2
839: , p_term_eff_date_from DATE
840: , p_term_eff_date_to DATE

Line 837: , p_location_id per_assignments_f.location_id%TYPE

833: --
834: CURSOR lcu_assact_r( p_payroll_action_id_arch pay_payroll_actions.payroll_action_id%TYPE
835: , p_business_group_id per_assignments_f.business_group_id%TYPE
836: , p_organization_id per_assignments_f.organization_id%TYPE
837: , p_location_id per_assignments_f.location_id%TYPE
838: , p_include_term_flag VARCHAR2
839: , p_term_eff_date_from DATE
840: , p_term_eff_date_to DATE
841: , p_effective_date DATE

Line 846: FROM per_assignments_f PAA

842: )
843: IS
844: SELECT PJEDV.assignment_id
845: ,PJEDV.effective_date
846: FROM per_assignments_f PAA
847: ,per_people_f PAP
848: ,pay_assignment_actions PAS
849: ,per_jp_empdet_emp_v PJEDV
850: ,per_periods_of_service PPOF

Line 889: , p_business_group_id per_assignments_f.business_group_id%TYPE

885: )
886: );
887: --
888: CURSOR lcu_assact( p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE
889: , p_business_group_id per_assignments_f.business_group_id%TYPE
890: , p_organization_id per_assignments_f.organization_id%TYPE
891: , p_location_id per_assignments_f.location_id%TYPE
892: , p_include_term_flag VARCHAR2
893: , p_term_eff_date_from DATE

Line 890: , p_organization_id per_assignments_f.organization_id%TYPE

886: );
887: --
888: CURSOR lcu_assact( p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE
889: , p_business_group_id per_assignments_f.business_group_id%TYPE
890: , p_organization_id per_assignments_f.organization_id%TYPE
891: , p_location_id per_assignments_f.location_id%TYPE
892: , p_include_term_flag VARCHAR2
893: , p_term_eff_date_from DATE
894: , p_term_eff_date_to DATE

Line 891: , p_location_id per_assignments_f.location_id%TYPE

887: --
888: CURSOR lcu_assact( p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE
889: , p_business_group_id per_assignments_f.business_group_id%TYPE
890: , p_organization_id per_assignments_f.organization_id%TYPE
891: , p_location_id per_assignments_f.location_id%TYPE
892: , p_include_term_flag VARCHAR2
893: , p_term_eff_date_from DATE
894: , p_term_eff_date_to DATE
895: , p_effective_date DATE

Line 900: FROM per_assignments_f PAA

896: )
897: IS
898: SELECT PJEDV.assignment_id
899: ,PJEDV.effective_date
900: FROM per_assignments_f PAA
901: ,per_people_f PAP
902: ,pay_assignment_actions PAS
903: ,per_periods_of_service PPS
904: ,per_jp_empdet_emp_v PJEDV

Line 1499: TYPE asmt_hist_type IS RECORD( assignment_number per_assignments_f.assignment_number%TYPE

1495: l_asmnt_count NUMBER;
1496: i NUMBER;
1497: j NUMBER:=0;-- Bug 8843783
1498: --
1499: TYPE asmt_hist_type IS RECORD( assignment_number per_assignments_f.assignment_number%TYPE
1500: ,organization_name hr_organization_units.name%TYPE
1501: ,job per_jobs_tl.name %TYPE
1502: ,position per_positions.name%TYPE
1503: ,grade per_grades_tl.name%TYPE

Line 1504: ,start_date per_assignments_f.effective_start_date%TYPE

1500: ,organization_name hr_organization_units.name%TYPE
1501: ,job per_jobs_tl.name %TYPE
1502: ,position per_positions.name%TYPE
1503: ,grade per_grades_tl.name%TYPE
1504: ,start_date per_assignments_f.effective_start_date%TYPE
1505: ,end_date per_assignments_f.effective_end_date%TYPE
1506: );--8740684
1507: TYPE gt_asmnt_tbl IS TABLE OF asmt_hist_type INDEX BY binary_integer; -- 8740684
1508: lt_asmnt_tbl gt_asmnt_tbl;--8740684

Line 1505: ,end_date per_assignments_f.effective_end_date%TYPE

1501: ,job per_jobs_tl.name %TYPE
1502: ,position per_positions.name%TYPE
1503: ,grade per_grades_tl.name%TYPE
1504: ,start_date per_assignments_f.effective_start_date%TYPE
1505: ,end_date per_assignments_f.effective_end_date%TYPE
1506: );--8740684
1507: TYPE gt_asmnt_tbl IS TABLE OF asmt_hist_type INDEX BY binary_integer; -- 8740684
1508: lt_asmnt_tbl gt_asmnt_tbl;--8740684
1509: lt_res_tb per_jp_empdet_report_pkg.gt_job_tbl; -- Bug No 8843783

Line 1937: FROM per_assignments_f PPF

1933: SELECT PIMG.parent_id
1934: ,PIMG.image
1935: FROM per_images PIMG
1936: WHERE PIMG.parent_id = (SELECT DISTINCT PPF.person_id
1937: FROM per_assignments_f PPF
1938: WHERE PPF.assignment_id = p_assignment_id
1939: );
1940: --
1941: CURSOR lcu_emp_det_blob(p_mag_asg_action_id NUMBER)