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_IE_P35 dependencies on PAY_ALL_PAYROLLS_F

Line 33: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;

29: l_end_date DATE;
30: l_bg_id NUMBER;
31: l_segment4 hr_soft_coding_keyflex.segment4%TYPE;
32: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
33: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
34:
35:
36: -- declaring the pl/sql table for storing the first 5 contribution class values
37: TYPE type_context_value_tab IS TABLE OF pay_run_result_values.result_value%TYPE

Line 811: pay_all_payrolls_f pap,

807: ,fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) aamin -- 8322991
808: FROM per_assignments_f asg,
809: pay_assignment_actions paa,
810: pay_payroll_actions ppa,
811: pay_all_payrolls_f pap,
812: per_time_periods ptp,
813: hr_soft_coding_keyflex flex
814: WHERE paa.source_action_id IS NULL
815: AND paa.payroll_action_id = ppa.payroll_action_id

Line 841: ,pay_all_payrolls_f pay

837: FROM per_assignments_f paf,
838: pay_assignment_actions paa1, --Bug fix 4130665
839: pay_payroll_actions ppa1,
840: per_time_periods ptp1 --Tar 15081088.6
841: ,pay_all_payrolls_f pay
842: ,hr_soft_coding_keyflex flex1
843: WHERE paf.person_id = asg.person_id
844: -- AND paf.primary_flag = 'Y'
845: --Added for bug fix 4130665

Line 889: -- , pay_all_payrolls_f pay

885: AND (l_set_flag ='I' AND EXISTS(SELECT 1
886: FROM hr_assignment_set_amendments hasa
887: , hr_assignment_sets has
888: , per_assignments_f paf
889: -- , pay_all_payrolls_f pay
890: -- , hr_soft_coding_keyflex hflex
891: WHERE has.assignment_set_id = hasa.assignment_set_id
892: AND has.business_group_id = l_bg_id
893: AND has.assignment_set_id = l_assignment_set_id

Line 903: -- , pay_all_payrolls_f pay

899: OR l_set_flag = 'E' AND NOT EXISTS(SELECT 1
900: FROM hr_assignment_set_amendments hasa
901: , hr_assignment_sets has
902: , per_assignments_f paf
903: -- , pay_all_payrolls_f pay
904: -- , hr_soft_coding_keyflex hflex
905: WHERE has.assignment_set_id = hasa.assignment_set_id
906: AND has.business_group_id = l_bg_id
907: AND has.assignment_set_id = l_assignment_set_id

Line 920: pay_all_payrolls_f ppf_p35,

916: SELECT 1
917: FROM pay_assignment_actions paa_p35,
918: pay_payroll_actions ppa_p35,
919: per_assignments_f paaf_p35,
920: pay_all_payrolls_f ppf_p35,
921: hr_soft_coding_keyflex flex_p35,
922: pay_action_interlocks plock
923: WHERE ppa_p35.report_type = 'IEP35'
924: AND paa_p35.action_status = 'C'

Line 1477: l_period_type pay_all_payrolls_f.period_type%TYPE; --Bug 4154171

1473: l_arch_total_notional_pay pay_action_information.action_information4%TYPE;
1474: l_arch_total_share_scheme pay_action_information.action_information4%TYPE; --16306646
1475: l_p35_taxable_pay_adjust pay_action_information.action_information4%TYPE; --16306646
1476: l_p35_gross_pay_adjust pay_action_information.action_information4%TYPE; --16306646
1477: l_period_type pay_all_payrolls_f.period_type%TYPE; --Bug 4154171
1478: -- Temporary variable to hold values when Class K or M exists
1479: l_temp_prsi_cont pay_action_information.action_information4%TYPE := NULL;
1480: l_oth_arch_ovn pay_action_information.object_version_number%TYPE;
1481: l_pds_id per_periods_of_service.period_of_service_id%TYPE;

Line 2012: pay_all_payrolls_f papf,

2008: per_periods_of_service pps,
2009: per_assignments_f paf,
2010: per_addresses pad,
2011: -- pay_ie_paye_details_f payef, --Bug 4154171
2012: pay_all_payrolls_f papf,
2013: pay_payroll_actions ppa
2014: WHERE pai.locking_action_id = p_locked_action
2015: AND paa.assignment_action_id = pai.locked_action_id
2016: -- Added for bug 5874653

Line 2043: FROM pay_all_payrolls_f papf1

2039: AND paf.person_id = pps.person_id
2040: AND papf.payroll_id = paf.payroll_id
2041: AND papf.effective_end_date =
2042: (SELECT MAX (papf1.effective_end_date)
2043: FROM pay_all_payrolls_f papf1
2044: WHERE papf1.payroll_id = papf.payroll_id
2045: AND papf1.effective_start_date <= l_end_date
2046: AND papf1.effective_end_date >= l_start_date);
2047:

Line 2249: pay_all_payrolls_f papf,

2245: per_periods_of_service pps,
2246: per_assignments_f paf,
2247: per_addresses pad,
2248: -- pay_ie_paye_details_f payef,
2249: pay_all_payrolls_f papf,
2250: pay_payroll_actions ppa
2251: WHERE paa.assignment_action_id = p_locked_action
2252: -- Added for bug 5874653
2253: AND ppa.payroll_action_id = paa.payroll_action_id

Line 2287: FROM pay_all_payrolls_f papf1

2283: )*/
2284: AND papf.payroll_id = paf.payroll_id
2285: AND papf.effective_end_date =
2286: (SELECT MAX (papf1.effective_end_date)
2287: FROM pay_all_payrolls_f papf1
2288: WHERE papf1.payroll_id = papf.payroll_id
2289: AND papf1.effective_start_date <= l_end_date
2290: AND papf1.effective_end_date >= l_start_date);
2291:

Line 2403: ,pay_all_payrolls_f pay

2399: ORDER BY actual_termination_date desc; */
2400: SELECT max(pps.period_of_service_id)
2401: FROM per_periods_of_service pps
2402: ,per_assignments_f asg
2403: ,pay_all_payrolls_f pay
2404: ,hr_soft_coding_keyflex flex
2405: WHERE pps.person_id = v_person_id
2406: AND pps.person_id = asg.person_id
2407: AND asg.period_of_service_id <> pps.period_of_service_id