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 803: pay_all_payrolls_f pap,

799: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) aa -- Bug 4672715
800: FROM per_assignments_f asg,
801: pay_assignment_actions paa,
802: pay_payroll_actions ppa,
803: pay_all_payrolls_f pap,
804: per_time_periods ptp,
805: hr_soft_coding_keyflex flex
806: WHERE paa.source_action_id IS NULL
807: AND paa.payroll_action_id = ppa.payroll_action_id

Line 833: ,pay_all_payrolls_f pay

829: FROM per_assignments_f paf,
830: pay_assignment_actions paa1, --Bug fix 4130665
831: pay_payroll_actions ppa1,
832: per_time_periods ptp1 --Tar 15081088.6
833: ,pay_all_payrolls_f pay
834: ,hr_soft_coding_keyflex flex1
835: WHERE paf.person_id = asg.person_id
836: -- AND paf.primary_flag = 'Y'
837: --Added for bug fix 4130665

Line 881: -- , pay_all_payrolls_f pay

877: AND (l_set_flag ='I' AND EXISTS(SELECT 1
878: FROM hr_assignment_set_amendments hasa
879: , hr_assignment_sets has
880: , per_assignments_f paf
881: -- , pay_all_payrolls_f pay
882: -- , hr_soft_coding_keyflex hflex
883: WHERE has.assignment_set_id = hasa.assignment_set_id
884: AND has.business_group_id = l_bg_id
885: AND has.assignment_set_id = l_assignment_set_id

Line 895: -- , pay_all_payrolls_f pay

891: OR l_set_flag = 'E' AND NOT EXISTS(SELECT 1
892: FROM hr_assignment_set_amendments hasa
893: , hr_assignment_sets has
894: , per_assignments_f paf
895: -- , pay_all_payrolls_f pay
896: -- , hr_soft_coding_keyflex hflex
897: WHERE has.assignment_set_id = hasa.assignment_set_id
898: AND has.business_group_id = l_bg_id
899: AND has.assignment_set_id = l_assignment_set_id

Line 912: pay_all_payrolls_f ppf_p35,

908: SELECT 1
909: FROM pay_assignment_actions paa_p35,
910: pay_payroll_actions ppa_p35,
911: per_assignments_f paaf_p35,
912: pay_all_payrolls_f ppf_p35,
913: hr_soft_coding_keyflex flex_p35,
914: pay_action_interlocks plock
915: WHERE ppa_p35.report_type = 'IEP35'
916: AND paa_p35.action_status = 'C'

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

1211: l_arch_previous_emp_tax pay_action_information.action_information29%TYPE;
1212: l_arch_pr_indicator pay_action_information.action_information30%TYPE;
1213: l_arch_action_info_id NUMBER;
1214: l_arch_total_notional_pay pay_action_information.action_information4%TYPE;
1215: l_period_type pay_all_payrolls_f.period_type%TYPE; --Bug 4154171
1216: -- Temporary variable to hold values when Class K or M exists
1217: l_temp_prsi_cont pay_action_information.action_information4%TYPE := NULL;
1218: l_oth_arch_ovn pay_action_information.object_version_number%TYPE;
1219: l_pds_id per_periods_of_service.period_of_service_id%TYPE;

Line 1639: pay_all_payrolls_f papf,

1635: per_periods_of_service pps,
1636: per_assignments_f paf,
1637: per_addresses pad,
1638: -- pay_ie_paye_details_f payef, --Bug 4154171
1639: pay_all_payrolls_f papf,
1640: pay_payroll_actions ppa
1641: WHERE pai.locking_action_id = p_locked_action
1642: AND paa.assignment_action_id = pai.locked_action_id
1643: -- Added for bug 5874653

Line 1670: FROM pay_all_payrolls_f papf1

1666: AND paf.person_id = pps.person_id
1667: AND papf.payroll_id = paf.payroll_id
1668: AND papf.effective_end_date =
1669: (SELECT MAX (papf1.effective_end_date)
1670: FROM pay_all_payrolls_f papf1
1671: WHERE papf1.payroll_id = papf.payroll_id
1672: AND papf1.effective_start_date <= l_end_date
1673: AND papf1.effective_end_date >= l_start_date);
1674:

Line 1842: pay_all_payrolls_f papf,

1838: per_periods_of_service pps,
1839: per_assignments_f paf,
1840: per_addresses pad,
1841: -- pay_ie_paye_details_f payef,
1842: pay_all_payrolls_f papf,
1843: pay_payroll_actions ppa
1844: WHERE paa.assignment_action_id = p_locked_action
1845: -- Added for bug 5874653
1846: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1880: FROM pay_all_payrolls_f papf1

1876: )*/
1877: AND papf.payroll_id = paf.payroll_id
1878: AND papf.effective_end_date =
1879: (SELECT MAX (papf1.effective_end_date)
1880: FROM pay_all_payrolls_f papf1
1881: WHERE papf1.payroll_id = papf.payroll_id
1882: AND papf1.effective_start_date <= l_end_date
1883: AND papf1.effective_end_date >= l_start_date);
1884:

Line 1988: ,pay_all_payrolls_f pay

1984: ORDER BY actual_termination_date desc; */
1985: SELECT max(pps.period_of_service_id)
1986: FROM per_periods_of_service pps
1987: ,per_assignments_f asg
1988: ,pay_all_payrolls_f pay
1989: ,hr_soft_coding_keyflex flex
1990: WHERE pps.person_id = v_person_id
1991: AND pps.person_id = asg.person_id
1992: AND asg.period_of_service_id <> pps.period_of_service_id