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

Line 410: p_assignment_id in per_all_assignments_f.assignment_id%type,

406:
407: function periods_since_hire_date
408: (
409: p_payroll_id in number,
410: p_assignment_id in per_all_assignments_f.assignment_id%type,
411: p_tax_unit_id in pay_assignment_actions.tax_unit_id%type, --2610141
412: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type, /*Bug 4451088 */
413: p_period_num in number,
414: p_period_start in date,

Line 434: cursor get_legal_emp_start_date (c_assignment_id per_all_assignments_f.assignment_id%type) is

430: Enrolled into the legal employer existing as of this period start date */
431:
432: /*Bug 4474896 - Modified cursor to pick the correct effective start date for the legal employer*/
433:
434: cursor get_legal_emp_start_date (c_assignment_id per_all_assignments_f.assignment_id%type) is
435: select min(effective_start_date)
436: from per_all_assignments_f paf,
437: hr_soft_coding_keyflex hsck
438: where paf.assignment_id = c_assignment_id

Line 436: from per_all_assignments_f paf,

432: /*Bug 4474896 - Modified cursor to pick the correct effective start date for the legal employer*/
433:
434: cursor get_legal_emp_start_date (c_assignment_id per_all_assignments_f.assignment_id%type) is
435: select min(effective_start_date)
436: from per_all_assignments_f paf,
437: hr_soft_coding_keyflex hsck
438: where paf.assignment_id = c_assignment_id
439: and paf.SOFT_CODING_KEYFLEX_ID = hsck.soft_coding_keyflex_id
440: and hsck.segment1 = fnd_number.number_to_canonical(p_tax_unit_id) -- Bug 13793176

Line 668: ( p_assignment_id in per_all_assignments_f.assignment_id%TYPE,

664: per tax spread deductions for the previous year when total average earnings are negative */
665: /* Bug#4467198 - Modified the function to take care of legal employer changes. Introduced following
666: parameters in the function p_use_tax_flag, p_payroll_id, p_assignment_action_id*/
667: FUNCTION calculate_asg_prev_value
668: ( p_assignment_id in per_all_assignments_f.assignment_id%TYPE,
669: p_business_group_id in hr_all_organization_units.organization_id%TYPE,
670: p_date_earned in date,
671: p_tax_unit_id in hr_all_organization_units.organization_id%TYPE,
672: p_assignment_action_id IN number,

Line 725: ( c_assignment_id in per_all_assignments_f.assignment_id%TYPE,

721: -- If there exists any LE changes, then it gets the max
722: -- Assignment Action ID .
723: -----------------------------------------------------------------------
724: CURSOR c_get_prev_year_max_asg_act_id
725: ( c_assignment_id in per_all_assignments_f.assignment_id%TYPE,
726: c_business_group_id in hr_all_organization_units.organization_id%TYPE,
727: c_fin_start_date in date,
728: c_fin_end_date in date)
729: IS

Line 741: per_all_assignments_f paaf

737: (
738: SELECT MAX(paa.action_sequence)
739: FROM pay_assignment_actions paa,
740: pay_payroll_actions ppa,
741: per_all_assignments_f paaf
742: WHERE ppa.business_group_id = c_business_group_id
743: AND paaf.assignment_id = c_assignment_id
744: AND paa.assignment_id = paaf.assignment_id
745: AND paa.action_status='C'

Line 755: ( c_assignment_id in per_all_assignments_f.assignment_id%TYPE,

751: ORDER BY date_earned desc;
752:
753:
754: CURSOR c_get_pre_le_max_asg_act_id
755: ( c_assignment_id in per_all_assignments_f.assignment_id%TYPE,
756: c_business_group_id in hr_all_organization_units.organization_id%TYPE,
757: c_fin_start_date in date,
758: c_fin_end_date in date)
759: IS

Line 771: per_all_assignments_f paaf

767: (
768: SELECT MAX(paa.action_sequence)
769: FROM pay_assignment_actions paa,
770: pay_payroll_actions ppa,
771: per_all_assignments_f paaf
772: WHERE ppa.business_group_id = c_business_group_id
773: AND paaf.assignment_id = c_assignment_id
774: AND paa.action_status='C'
775: AND paa.assignment_id = paaf.assignment_id

Line 877: CURSOR c_check_payroll_run (c_assignment_id in per_all_assignments_f.assignment_id%TYPE,

873: AND ppa.payroll_action_id = paa.payroll_action_id;
874:
875: /* Bug#4467198 - Use the below cursor to check if this is the first for the assignment in this year*/
876:
877: CURSOR c_check_payroll_run (c_assignment_id in per_all_assignments_f.assignment_id%TYPE,
878: c_business_group_id in hr_all_organization_units.organization_id%TYPE,
879: c_start_date in date,
880: c_end_date in date)
881: IS

Line 2801: function check_fixed_deduction(p_assignment_id in per_all_assignments_f.assignment_id%TYPE, p_date_earned in date)

2797: end calculate_tax;
2798:
2799:
2800:
2801: function check_fixed_deduction(p_assignment_id in per_all_assignments_f.assignment_id%TYPE, p_date_earned in date)
2802: return varchar2 is
2803: /* Bug 4374115 - Added check for Reverse Runs */
2804: cursor check_fixed_deduction(p_assignment_id in number, p_date_earned in date)
2805: is

Line 2815: per_all_assignments_f paaf

2811: pay_run_results prr,
2812: pay_assignment_actions paa,
2813: pay_payroll_actions ppa,
2814: per_time_periods ptp,
2815: per_all_assignments_f paaf
2816: where pet.element_name = 'Extra Withholding Payments'
2817: and piv.name='Withholding Amount'
2818: and pet.element_type_id=piv.element_type_id
2819: and piv.input_value_id=prrv.input_value_id

Line 3056: p_pay_bases_id in per_all_assignments_f.pay_basis_id%TYPE

3052: FUNCTION get_salary_basis_hours
3053: (
3054: p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,
3055: p_element_type_id in pay_element_entries_f.element_entry_id%TYPE,
3056: p_pay_bases_id in per_all_assignments_f.pay_basis_id%TYPE
3057: )
3058: RETURN NUMBER IS
3059:
3060: l_element_type_id pay_element_entries_f.element_entry_id%TYPE;

Line 3451: ( p_assignment_id in per_all_assignments_f.assignment_id%type,

3447: end;
3448:
3449: /* bug6809877 - Adeed new function get_etp_pay_component */
3450: function get_etp_pay_component
3451: ( p_assignment_id in per_all_assignments_f.assignment_id%type,
3452: p_date_earned in date) return varchar2 is
3453:
3454: cursor etp_pay_csr ( c_assignment_id per_all_assignments_f.assignment_id%type,
3455: c_date_earned date) is

Line 3454: cursor etp_pay_csr ( c_assignment_id per_all_assignments_f.assignment_id%type,

3450: function get_etp_pay_component
3451: ( p_assignment_id in per_all_assignments_f.assignment_id%type,
3452: p_date_earned in date) return varchar2 is
3453:
3454: cursor etp_pay_csr ( c_assignment_id per_all_assignments_f.assignment_id%type,
3455: c_date_earned date) is
3456: select peev.screen_entry_value
3457: from pay_element_types_f pet,
3458: pay_input_values_f piv,

Line 4540: l_soft_code_id per_all_assignments_f.SOFT_CODING_KEYFLEX_ID%TYPE := -1;

4536: l_emp_num per_all_people_f.employee_number%TYPE;
4537: l_ovn NUMBER := -1;
4538: l_start DATE;
4539: l_asg_mode varchar2(60);
4540: l_soft_code_id per_all_assignments_f.SOFT_CODING_KEYFLEX_ID%TYPE := -1;
4541: l_legal_employer_id NUMBER := -1;
4542: l_le_id NUMBER := -1;
4543: l_load_flag VARCHAR2(10);
4544:

Line 4548: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%type;

4544:
4545: l_cagr_grade_def_id number;
4546: l_cagr_concatenated_segments varchar2(2000);
4547: l_comment_id number;
4548: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%type;
4549: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4550: l_no_managers_warning boolean;
4551: l_other_manager_warning boolean;
4552: not_inserted boolean := TRUE;

Line 4728: from per_all_assignments_f

4724:
4725: CURSOR get_bg_id(p_assignment_id IN NUMBER)
4726: IS
4727: select distinct business_group_id
4728: from per_all_assignments_f
4729: where assignment_id = p_assignment_id;
4730:
4731: CURSOR get_emp_details(p_assignment_id IN NUMBER)
4732: IS

Line 4737: from per_all_assignments_f

4733: SELECT pap.FULL_NAME,pap.EMPLOYEE_NUMBER
4734: from per_all_people_f pap
4735: where pap.person_id in
4736: ( select distinct person_id
4737: from per_all_assignments_f
4738: where assignment_id = p_assignment_id
4739: )
4740: and pap.effective_end_date = ( select max(papf.effective_end_date)
4741: from per_all_people_f papf

Line 4744: from per_all_assignments_f

4740: and pap.effective_end_date = ( select max(papf.effective_end_date)
4741: from per_all_people_f papf
4742: where papf.person_id in
4743: ( select distinct person_id
4744: from per_all_assignments_f
4745: where assignment_id = p_assignment_id
4746: ));
4747: -- and g_date between pap.effective_start_date and pap.effective_end_date;
4748:

Line 4753: FROM per_all_assignments_f

4749:
4750: CURSOR csr_fut_asg_rec(p_assignment_id IN NUMBER)
4751: IS
4752: SELECT COUNT(*)
4753: FROM per_all_assignments_f
4754: where assignment_id = p_assignment_id
4755: and ( effective_start_date > g_date or ( effective_end_date > g_date and effective_end_date <> to_date('31-12-4712','dd-mm-yyyy'))) ;
4756:
4757: CURSOR csr_asg_det(p_assignment_id IN NUMBER)

Line 4760: from per_all_assignments_f

4756:
4757: CURSOR csr_asg_det(p_assignment_id IN NUMBER)
4758: IS
4759: SELECT object_version_number,effective_start_date,soft_coding_keyflex_id
4760: from per_all_assignments_f
4761: where assignment_id = p_assignment_id
4762: and g_date between effective_start_date and effective_end_date
4763: and effective_end_date = to_date('31-12-4712','dd-mm-yyyy');
4764:

Line 4780: FROM per_all_assignments_f

4776:
4777: -- cursor for first record of assignment
4778: cursor fut_fir_asg_rec(p_assignment_id IN NUMBER) IS
4779: SELECT assignment_id,effective_start_date,effective_end_date,object_version_number,soft_coding_keyflex_id
4780: FROM per_all_assignments_f
4781: where assignment_id = p_assignment_id
4782: and g_date between effective_start_date and effective_end_date;
4783:
4784: -- cursor for all future records of assignment post 01-jul-2012

Line 4787: FROM per_all_assignments_f

4783:
4784: -- cursor for all future records of assignment post 01-jul-2012
4785: cursor fut_all_next_asg_rec(p_assignment_id IN NUMBER) IS
4786: SELECT assignment_id,effective_start_date,effective_end_date,object_version_number,soft_coding_keyflex_id
4787: FROM per_all_assignments_f
4788: where assignment_id = p_assignment_id
4789: and effective_start_date > g_date;
4790:
4791: -- cursor for number of future records of assignment post 01-jul-2012

Line 4794: FROM per_all_assignments_f

4790:
4791: -- cursor for number of future records of assignment post 01-jul-2012
4792: cursor cnt_fut_asg_rec(p_assignment_id IN NUMBER) IS
4793: SELECT count(*)
4794: FROM per_all_assignments_f
4795: where assignment_id = p_assignment_id
4796: and effective_start_date > g_date;
4797:
4798: -- cursor for first record of element entry