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 545: FROM PER_ALL_ASSIGNMENTS_F ASG

541: ,HOURLY_SALARIED_CODE
542: INTO p_person_id
543: ,p_business_group_id
544: ,l_asg_hour_sal
545: FROM PER_ALL_ASSIGNMENTS_F ASG
546: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
547: AND p_effective_date BETWEEN ASG.EFFECTIVE_START_DATE
548: AND ASG.EFFECTIVE_END_DATE;
549: EXCEPTION

Line 580: FROM PER_ALL_ASSIGNMENTS_F ASG

576: ,HR_ORGANIZATION_INFORMATION hoi2
577: ,HR_ORGANIZATION_INFORMATION hoi3
578: ,HR_ORGANIZATION_INFORMATION hoi4
579: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
580: FROM PER_ALL_ASSIGNMENTS_F ASG
581: ,HR_SOFT_CODING_KEYFLEX SCL
582: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
583: AND ASG.SOFT_CODING_KEYFLEX_ID = SCL.SOFT_CODING_KEYFLEX_ID
584: AND P_EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE ) X

Line 6759: FROM per_all_assignments_f asg1

6755: CURSOR get_details(p_assignment_id NUMBER , p_effective_date DATE ) IS
6756: SELECT ee.element_entry_id element_entry_id
6757: , eev1.screen_entry_value screen_entry_value
6758: , iv1.name
6759: FROM per_all_assignments_f asg1
6760: ,per_all_assignments_f asg2
6761: ,per_all_people_f per
6762: ,pay_element_links_f el
6763: ,pay_element_types_f et

Line 6760: ,per_all_assignments_f asg2

6756: SELECT ee.element_entry_id element_entry_id
6757: , eev1.screen_entry_value screen_entry_value
6758: , iv1.name
6759: FROM per_all_assignments_f asg1
6760: ,per_all_assignments_f asg2
6761: ,per_all_people_f per
6762: ,pay_element_links_f el
6763: ,pay_element_types_f et
6764: ,pay_input_values_f iv1

Line 7053: FROM per_all_assignments_f asg1

7049: CURSOR get_details(p_assignment_id NUMBER , p_effective_date DATE, effdt DATE ) IS
7050: SELECT ee.element_entry_id element_entry_id
7051: , eev1.screen_entry_value screen_entry_value
7052: , iv1.name
7053: FROM per_all_assignments_f asg1
7054: ,per_all_assignments_f asg2
7055: ,per_all_people_f per
7056: ,pay_element_links_f el
7057: ,pay_element_types_f et

Line 7054: ,per_all_assignments_f asg2

7050: SELECT ee.element_entry_id element_entry_id
7051: , eev1.screen_entry_value screen_entry_value
7052: , iv1.name
7053: FROM per_all_assignments_f asg1
7054: ,per_all_assignments_f asg2
7055: ,per_all_people_f per
7056: ,pay_element_links_f el
7057: ,pay_element_types_f et
7058: ,pay_input_values_f iv1

Line 7219: FROM per_all_assignments_f asg1

7215: CURSOR get_details(p_assignment_id NUMBER , p_effective_date DATE, effdt DATE ) IS
7216: SELECT ee.element_entry_id element_entry_id
7217: , eev1.screen_entry_value screen_entry_value
7218: , iv1.name
7219: FROM per_all_assignments_f asg1
7220: ,per_all_assignments_f asg2
7221: ,per_all_people_f per
7222: ,pay_element_links_f el
7223: ,pay_element_types_f et

Line 7220: ,per_all_assignments_f asg2

7216: SELECT ee.element_entry_id element_entry_id
7217: , eev1.screen_entry_value screen_entry_value
7218: , iv1.name
7219: FROM per_all_assignments_f asg1
7220: ,per_all_assignments_f asg2
7221: ,per_all_people_f per
7222: ,pay_element_links_f el
7223: ,pay_element_types_f et
7224: ,pay_input_values_f iv1

Line 7495: pay_assignment_actions paa, per_all_assignments_f asgmt, per_all_people_f pap

7491:
7492: --
7493: CURSOR csr_get_person_id(p_assignment_action_id NUMBER) IS
7494: SELECT pap.person_id FROM
7495: pay_assignment_actions paa, per_all_assignments_f asgmt, per_all_people_f pap
7496: WHERE paa.assignment_action_id = p_assignment_action_id
7497: AND paa.assignment_id = asgmt.assignment_id
7498: AND asgmt.person_id = pap.person_id;
7499:

Line 7579: pay_assignment_actions paa, per_all_assignments_f asgmt, per_all_people_f pap

7575:
7576: --
7577: CURSOR csr_get_person_id(p_assignment_action_id NUMBER) IS
7578: SELECT pap.person_id FROM
7579: pay_assignment_actions paa, per_all_assignments_f asgmt, per_all_people_f pap
7580: WHERE paa.assignment_action_id = p_assignment_action_id
7581: AND paa.assignment_id = asgmt.assignment_id
7582: AND asgmt.person_id = pap.person_id;
7583:

Line 7684: FROM per_all_assignments_f paaf, per_time_periods ptp

7680:
7681: /* Cursor to get the payroll start date given absence*/
7682: CURSOR csr_intial_abs_pay_stdt (p_assignment_id number, p_initial_abs_start_date date) is
7683: SELECT ptp.start_date
7684: FROM per_all_assignments_f paaf, per_time_periods ptp
7685: WHERE paaf.assignment_id = p_assignment_id
7686: AND ptp.payroll_id = paaf.payroll_id
7687: AND p_initial_abs_start_date between ptp.start_date and ptp.end_date;
7688:

Line 7740: FROM per_all_assignments_f paaf,

7736:
7737: --Fix for Bug: 14778369 to get all status other than termination
7738: CURSOR csr_asg IS
7739: SELECT MAX(paaf.effective_end_date) effective_end_date
7740: FROM per_all_assignments_f paaf,
7741: PER_ASSIGNMENT_STATUS_TYPES sts
7742: WHERE paaf.business_group_id = p_business_group_id
7743: AND paaf.assignment_id = p_asg_id
7744: --AND paaf.assignment_status_type_id = 1; --Fix for Bug: 14778369

Line 7769: FROM PER_ALL_ASSIGNMENTS_F ASG

7765: p_effective_date IN DATE ,
7766: p_restrict_hol_to_6G OUT nocopy VARCHAR2) RETURN NUMBER IS
7767: CURSOR csr_person_id IS
7768: SELECT PERSON_ID
7769: FROM PER_ALL_ASSIGNMENTS_F ASG
7770: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
7771: AND p_effective_date BETWEEN ASG.EFFECTIVE_START_DATE
7772: AND ASG.EFFECTIVE_END_DATE;
7773:

Line 7792: FROM PER_ALL_ASSIGNMENTS_F ASG

7788: ,HR_ORGANIZATION_INFORMATION hoi2
7789: ,HR_ORGANIZATION_INFORMATION hoi3
7790: ,HR_ORGANIZATION_INFORMATION hoi4
7791: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
7792: FROM PER_ALL_ASSIGNMENTS_F ASG
7793: ,HR_SOFT_CODING_KEYFLEX SCL
7794: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
7795: AND ASG.SOFT_CODING_KEYFLEX_ID = SCL.SOFT_CODING_KEYFLEX_ID
7796: AND P_EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE ) X

Line 7897: FROM PER_ALL_ASSIGNMENTS_F ASG

7893: p_cms_contact_count OUT nocopy NUMBER) RETURN NUMBER IS
7894:
7895: CURSOR csr_person_id IS
7896: SELECT PERSON_ID
7897: FROM PER_ALL_ASSIGNMENTS_F ASG
7898: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
7899: AND p_abs_start_date BETWEEN ASG.EFFECTIVE_START_DATE
7900: AND ASG.EFFECTIVE_END_DATE;
7901: