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

Line 401: per_all_assignments_f as1

397: pay_payroll_actions appa2,
398: pay_assignment_actions act,
399: pay_assignment_actions act1,
400: pay_action_interlocks pai,
401: per_all_assignments_f as1
402: WHERE ppa.payroll_action_id = p_payroll_action_id
403: AND appa.consolidation_set_id = p_consolidation_id
404: AND appa.effective_date BETWEEN l_canonical_start_date
405: AND l_canonical_end_date

Line 837: per_all_assignments_f paa

833: /* Cursor to pick Hire Date*/
834: CURSOR csr_hire_date (p_assignment_id NUMBER) IS
835: SELECT trunc(date_start) date_start
836: FROM per_periods_of_service pps,
837: per_all_assignments_f paa
838: WHERE pps.period_of_service_id = paa.period_of_service_id
839: AND p_date_earned between paa.effective_start_date and paa.effective_end_date
840: AND paa.assignment_id = p_assignment_id;
841: /*Cursor to pick local unit*/

Line 844: from per_all_assignments_f paaf

840: AND paa.assignment_id = p_assignment_id;
841: /*Cursor to pick local unit*/
842: cursor csr_scl_details (p_assignment_id NUMBER) IS
843: SELECT segment2
844: from per_all_assignments_f paaf
845: ,HR_SOFT_CODING_KEYFLEX hsck
846: where paaf.assignment_id= p_assignment_id
847: and p_date_earned BETWEEN paaf.effective_start_date and paaf.effective_end_date
848: and paaf.SOFT_CODING_KEYFLEX_ID = hsck.SOFT_CODING_KEYFLEX_ID;

Line 2366: per_all_assignments_f paa

2362: IS
2363: CURSOR CSR_ACTUAL_TERM_DATE (p_assignment_id NUMBER) IS
2364: SELECT actual_termination_date
2365: FROM per_periods_of_service pps,
2366: per_all_assignments_f paa
2367: WHERE pps.period_of_service_id = paa.period_of_service_id
2368: AND p_date_earned between paa.effective_start_date and paa.effective_end_date
2369: AND paa.assignment_id = p_assignment_id;
2370: CURSOR get_details(p_assignment_id NUMBER , p_input_value VARCHAR2 ) IS

Line 2373: FROM per_all_assignments_f asg1

2369: AND paa.assignment_id = p_assignment_id;
2370: CURSOR get_details(p_assignment_id NUMBER , p_input_value VARCHAR2 ) IS
2371: SELECT ee.effective_start_date
2372: ,eev1.screen_entry_value screen_entry_value
2373: FROM per_all_assignments_f asg1
2374: ,per_all_assignments_f asg2
2375: ,per_all_people_f per
2376: ,pay_element_links_f el
2377: ,pay_element_types_f et

Line 2374: ,per_all_assignments_f asg2

2370: CURSOR get_details(p_assignment_id NUMBER , p_input_value VARCHAR2 ) IS
2371: SELECT ee.effective_start_date
2372: ,eev1.screen_entry_value screen_entry_value
2373: FROM per_all_assignments_f asg1
2374: ,per_all_assignments_f asg2
2375: ,per_all_people_f per
2376: ,pay_element_links_f el
2377: ,pay_element_types_f et
2378: ,pay_input_values_f iv1

Line 2403: FROM per_all_assignments_f asg1

2399: AND p_date_earned BETWEEN eev1.effective_start_date AND eev1.effective_end_date;
2400: CURSOR csr_tax_details(p_assignment_id NUMBER, p_input_value VARCHAR2) IS
2401: SELECT ee.effective_start_date
2402: ,eev1.screen_entry_value screen_entry_value
2403: FROM per_all_assignments_f asg1
2404: ,pay_element_links_f el
2405: ,pay_element_types_f et
2406: ,pay_input_values_f iv1
2407: ,pay_element_entries_f ee

Line 2424: FROM per_all_assignments_f paa,

2420: AND p_date_earned BETWEEN ee.effective_start_date AND ee.effective_end_date
2421: AND p_date_earned BETWEEN eev1.effective_start_date AND eev1.effective_end_date;
2422: CURSOR csr_tax_category (p_assignment_id NUMBER) IS
2423: SELECT segment13
2424: FROM per_all_assignments_f paa,
2425: hr_soft_coding_keyflex hsc
2426: WHERE
2427: paa.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
2428: AND p_date_earned BETWEEN paa.effective_start_date

Line 3777: FROM per_all_assignments_f paaf

3773: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
3774:
3775: CURSOR csr_scl_details (p_payroll_action_id pay_action_information.action_information1%TYPE , p_effective_date DATE ) IS
3776: SELECT DISTINCT segment2 local_unit , paaf.business_group_id
3777: FROM per_all_assignments_f paaf
3778: ,HR_SOFT_CODING_KEYFLEX hsck
3779: WHERE p_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
3780: AND paaf.SOFT_CODING_KEYFLEX_ID = hsck.SOFT_CODING_KEYFLEX_ID
3781: AND paaf.assignment_id IN