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

Line 90: FROM per_all_assignments_f asg1

86: ORDER BY paa.date_end desc ;
87:
88: CURSOR CSR_ELE_ENT_VAL_FETCH (l_asg_id number, l_eff_dt date, l_inp_val_name varchar2, l_start_dt date, l_end_dt date) IS
89: SELECT eev1.screen_entry_value screen_entry_value
90: FROM per_all_assignments_f asg1
91: ,per_all_assignments_f asg2
92: ,per_all_people_f per
93: ,pay_element_links_f el
94: ,pay_element_types_f et

Line 91: ,per_all_assignments_f asg2

87:
88: CURSOR CSR_ELE_ENT_VAL_FETCH (l_asg_id number, l_eff_dt date, l_inp_val_name varchar2, l_start_dt date, l_end_dt date) IS
89: SELECT eev1.screen_entry_value screen_entry_value
90: FROM per_all_assignments_f asg1
91: ,per_all_assignments_f asg2
92: ,per_all_people_f per
93: ,pay_element_links_f el
94: ,pay_element_types_f et
95: ,pay_input_values_f iv1

Line 139: FROM PER_ALL_ASSIGNMENTS_F PAA

135: AND pee.effective_end_date = enddate ;
136:
137: CURSOR CSR_CUR_ABS_PRORATED (P_ASSIGNMENT_ID NUMBER, P_EFFECTIVE_DATE DATE, P_ST_DT DATE, P_EN_DT DATE) IS
138: SELECT DATE_EARNED
139: FROM PER_ALL_ASSIGNMENTS_F PAA
140: ,PAY_PAYROLL_ACTIONS PPA
141: ,PAY_ASSIGNMENT_ACTIONS PASG
142: WHERE PAA.PAYROLL_ID = PPA.PAYROLL_ID
143: AND PAA.ASSIGNMENT_ID = P_ASSIGNMENT_ID

Line 220: FROM per_all_assignmeNts_f paaf, PER_TIME_PERIODS ptp

216:
217: /* Cursor to get the initial absence payroll start date */
218: CURSOR csr_intial_abs_pay_stdt (p_assignment_id in number, p_initial_abs_start_date in date) is
219: SELECT ptp.start_date
220: FROM per_all_assignmeNts_f paaf, PER_TIME_PERIODS ptp
221: WHERE paaf.assignment_id = p_assignment_id
222: AND ptp.payroll_id = paaf.payroll_id
223: AND p_initial_abs_start_date between ptp.start_date and ptp.end_date;
224:

Line 518: FROM PER_ALL_ASSIGNMENTS_F ASG

514: ,HOURLY_SALARIED_CODE
515: INTO p_person_id
516: ,p_business_group_id
517: ,l_asg_hour_sal
518: FROM PER_ALL_ASSIGNMENTS_F ASG
519: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
520: AND p_effective_date BETWEEN ASG.EFFECTIVE_START_DATE
521: AND ASG.EFFECTIVE_END_DATE;
522: EXCEPTION

Line 553: FROM PER_ALL_ASSIGNMENTS_F ASG

549: ,HR_ORGANIZATION_INFORMATION hoi2
550: ,HR_ORGANIZATION_INFORMATION hoi3
551: ,HR_ORGANIZATION_INFORMATION hoi4
552: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
553: FROM PER_ALL_ASSIGNMENTS_F ASG
554: ,HR_SOFT_CODING_KEYFLEX SCL
555: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
556: AND ASG.SOFT_CODING_KEYFLEX_ID = SCL.SOFT_CODING_KEYFLEX_ID
557: AND P_EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE ) X

Line 6659: FROM per_all_assignments_f asg1

6655: CURSOR get_details(p_assignment_id NUMBER , p_effective_date DATE ) IS
6656: SELECT ee.element_entry_id element_entry_id
6657: , eev1.screen_entry_value screen_entry_value
6658: , iv1.name
6659: FROM per_all_assignments_f asg1
6660: ,per_all_assignments_f asg2
6661: ,per_all_people_f per
6662: ,pay_element_links_f el
6663: ,pay_element_types_f et

Line 6660: ,per_all_assignments_f asg2

6656: SELECT ee.element_entry_id element_entry_id
6657: , eev1.screen_entry_value screen_entry_value
6658: , iv1.name
6659: FROM per_all_assignments_f asg1
6660: ,per_all_assignments_f asg2
6661: ,per_all_people_f per
6662: ,pay_element_links_f el
6663: ,pay_element_types_f et
6664: ,pay_input_values_f iv1

Line 6953: FROM per_all_assignments_f asg1

6949: CURSOR get_details(p_assignment_id NUMBER , p_effective_date DATE, effdt DATE ) IS
6950: SELECT ee.element_entry_id element_entry_id
6951: , eev1.screen_entry_value screen_entry_value
6952: , iv1.name
6953: FROM per_all_assignments_f asg1
6954: ,per_all_assignments_f asg2
6955: ,per_all_people_f per
6956: ,pay_element_links_f el
6957: ,pay_element_types_f et

Line 6954: ,per_all_assignments_f asg2

6950: SELECT ee.element_entry_id element_entry_id
6951: , eev1.screen_entry_value screen_entry_value
6952: , iv1.name
6953: FROM per_all_assignments_f asg1
6954: ,per_all_assignments_f asg2
6955: ,per_all_people_f per
6956: ,pay_element_links_f el
6957: ,pay_element_types_f et
6958: ,pay_input_values_f iv1

Line 7119: FROM per_all_assignments_f asg1

7115: CURSOR get_details(p_assignment_id NUMBER , p_effective_date DATE, effdt DATE ) IS
7116: SELECT ee.element_entry_id element_entry_id
7117: , eev1.screen_entry_value screen_entry_value
7118: , iv1.name
7119: FROM per_all_assignments_f asg1
7120: ,per_all_assignments_f asg2
7121: ,per_all_people_f per
7122: ,pay_element_links_f el
7123: ,pay_element_types_f et

Line 7120: ,per_all_assignments_f asg2

7116: SELECT ee.element_entry_id element_entry_id
7117: , eev1.screen_entry_value screen_entry_value
7118: , iv1.name
7119: FROM per_all_assignments_f asg1
7120: ,per_all_assignments_f asg2
7121: ,per_all_people_f per
7122: ,pay_element_links_f el
7123: ,pay_element_types_f et
7124: ,pay_input_values_f iv1

Line 7395: pay_assignment_actions paa, per_all_assignments_f asgmt, per_all_people_f pap

7391:
7392: --
7393: CURSOR csr_get_person_id(p_assignment_action_id NUMBER) IS
7394: SELECT pap.person_id FROM
7395: pay_assignment_actions paa, per_all_assignments_f asgmt, per_all_people_f pap
7396: WHERE paa.assignment_action_id = p_assignment_action_id
7397: AND paa.assignment_id = asgmt.assignment_id
7398: AND asgmt.person_id = pap.person_id;
7399:

Line 7479: pay_assignment_actions paa, per_all_assignments_f asgmt, per_all_people_f pap

7475:
7476: --
7477: CURSOR csr_get_person_id(p_assignment_action_id NUMBER) IS
7478: SELECT pap.person_id FROM
7479: pay_assignment_actions paa, per_all_assignments_f asgmt, per_all_people_f pap
7480: WHERE paa.assignment_action_id = p_assignment_action_id
7481: AND paa.assignment_id = asgmt.assignment_id
7482: AND asgmt.person_id = pap.person_id;
7483:

Line 7584: FROM per_all_assignments_f paaf, per_time_periods ptp

7580:
7581: /* Cursor to get the payroll start date given absence*/
7582: CURSOR csr_intial_abs_pay_stdt (p_assignment_id number, p_initial_abs_start_date date) is
7583: SELECT ptp.start_date
7584: FROM per_all_assignments_f paaf, per_time_periods ptp
7585: WHERE paaf.assignment_id = p_assignment_id
7586: AND ptp.payroll_id = paaf.payroll_id
7587: AND p_initial_abs_start_date between ptp.start_date and ptp.end_date;
7588:

Line 7639: FROM per_all_assignments_f paaf

7635: p_pay_proc_period_start_date IN DATE, p_pay_proc_period_end_date IN DATE) RETURN DATE IS
7636:
7637: CURSOR csr_asg IS
7638: SELECT MAX(paaf.effective_end_date) effective_end_date
7639: FROM per_all_assignments_f paaf
7640: WHERE paaf.business_group_id = p_business_group_id
7641: AND paaf.assignment_id = p_asg_id
7642: AND paaf.assignment_status_type_id = 1;
7643:

Line 7664: FROM PER_ALL_ASSIGNMENTS_F ASG

7660: p_effective_date IN DATE ,
7661: p_restrict_hol_to_6G OUT nocopy VARCHAR2) RETURN NUMBER IS
7662: CURSOR csr_person_id IS
7663: SELECT PERSON_ID
7664: FROM PER_ALL_ASSIGNMENTS_F ASG
7665: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
7666: AND p_effective_date BETWEEN ASG.EFFECTIVE_START_DATE
7667: AND ASG.EFFECTIVE_END_DATE;
7668:

Line 7687: FROM PER_ALL_ASSIGNMENTS_F ASG

7683: ,HR_ORGANIZATION_INFORMATION hoi2
7684: ,HR_ORGANIZATION_INFORMATION hoi3
7685: ,HR_ORGANIZATION_INFORMATION hoi4
7686: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
7687: FROM PER_ALL_ASSIGNMENTS_F ASG
7688: ,HR_SOFT_CODING_KEYFLEX SCL
7689: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
7690: AND ASG.SOFT_CODING_KEYFLEX_ID = SCL.SOFT_CODING_KEYFLEX_ID
7691: AND P_EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE ) X

Line 7792: FROM PER_ALL_ASSIGNMENTS_F ASG

7788: p_cms_contact_count OUT nocopy NUMBER) RETURN NUMBER IS
7789:
7790: CURSOR csr_person_id IS
7791: SELECT PERSON_ID
7792: FROM PER_ALL_ASSIGNMENTS_F ASG
7793: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
7794: AND p_abs_start_date BETWEEN ASG.EFFECTIVE_START_DATE
7795: AND ASG.EFFECTIVE_END_DATE;
7796: