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_EOY_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

Line 430: l_parameter pay_payroll_actions.legislative_parameters%TYPE := NULL;

426: FUNCTION get_parameter
427: (p_parameter_string IN VARCHAR2
428: ,p_token IN VARCHAR) RETURN VARCHAR2 IS
429: --
430: l_parameter pay_payroll_actions.legislative_parameters%TYPE := NULL;
431: l_start_pos NUMBER;
432: l_delimiter VARCHAR2(1) := ' ';
433: --
434: BEGIN

Line 1017: FROM pay_payroll_actions

1013: SELECT business_group_id
1014: ,legislative_parameters
1015: ,pay_no_eoy_archive.get_parameter(legislative_parameters, 'LEGAL_EMPLOYER_ID') legal_employer_id
1016: ,fnd_date.canonical_to_date(pay_no_eoy_archive.get_parameter(legislative_parameters, 'DATE')) report_date
1017: FROM pay_payroll_actions
1018: WHERE payroll_action_id = p_payroll_action_id;
1019: --
1020: l_parameter_rec csr_PARAMS%ROWTYPE;
1021: --

Line 1229: ,pay_payroll_actions ppa

1225: ,'Y', orginf2.org_information1
1226: ,orginf1.org_information1) org_number
1227:
1228: FROM pay_assignment_actions paa
1229: ,pay_payroll_actions ppa
1230: ,pay_action_contexts pac1
1231: ,pay_action_contexts pac2
1232: ,ff_contexts ctx1
1233: ,ff_contexts ctx2

Line 1271: FROM pay_payroll_actions ppa

1267: ,p_business_group_id IN NUMBER
1268: ,p_legal_employer_id IN NUMBER
1269: ,p_assg_id IN NUMBER) IS
1270: SELECT max(paa.assignment_action_id)
1271: FROM pay_payroll_actions ppa
1272: ,pay_assignment_actions paa
1273: WHERE ppa.business_group_id = p_business_group_id
1274: AND ppa.action_type IN ('R','Q','I','B')
1275: AND ppa.action_status = 'C'

Line 1777: ,pay_payroll_actions ppa

1773: --
1774: p_sql :=
1775: 'SELECT DISTINCT per.person_id
1776: FROM per_people_f per
1777: ,pay_payroll_actions ppa
1778: WHERE ppa.payroll_action_id = :payroll_action_id
1779: AND per.business_group_id = ppa.business_group_id
1780: ORDER BY per.person_id';
1781: --

Line 1815: ,pay_payroll_actions ppa

1811: ,MAX(asg.effective_end_date) effective_end_date
1812: ,MAX(asg.effective_start_date) effective_start_date --Changes 2007/2008
1813: FROM per_all_assignments_f asg
1814: ,pay_assignment_actions paa
1815: ,pay_payroll_actions ppa
1816: ,pay_action_information ai
1817: ,pay_action_contexts ac1
1818: ,ff_contexts ctx1
1819: ,pay_action_contexts ac2

Line 2117: ,pay_payroll_actions ppa

2113: ,pay_action_contexts ac1
2114: ,ff_contexts ctx1
2115: ,pay_action_contexts ac2
2116: ,ff_contexts ctx2
2117: ,pay_payroll_actions ppa
2118: ,pay_run_results rr
2119: ,pay_run_result_values rrv
2120: ,pay_input_values_f pivf
2121: ,pay_user_tables t

Line 2293: ,pay_payroll_actions ppa

2289: ,pay_action_contexts ac1
2290: ,ff_contexts ctx1
2291: ,pay_action_contexts ac2
2292: ,ff_contexts ctx2
2293: ,pay_payroll_actions ppa
2294: ,pay_run_results rr
2295: ,pay_run_result_values rrv
2296: ,pay_input_values_f pivf
2297: ,pay_element_types_f petf

Line 2369: ,pay_payroll_actions ppa

2365: ,pay_action_contexts ac1
2366: ,ff_contexts ctx1
2367: ,pay_action_contexts ac2
2368: ,ff_contexts ctx2
2369: ,pay_payroll_actions ppa
2370: ,pay_run_results rr
2371: ,pay_run_result_values rrv
2372: ,pay_input_values_f pivf
2373: ,pay_element_types_f petf

Line 3786: from pay_payroll_actions ppa,

3782: IF p_payroll_action_id is null then
3783: BEGIN
3784: SELECT payroll_action_id
3785: into l_payroll_action_id
3786: from pay_payroll_actions ppa,
3787: fnd_conc_req_summary_v fcrs,
3788: fnd_conc_req_summary_v fcrs1
3789: WHERE fcrs.request_id = fnd_global.conc_request_id
3790: and fcrs.priority_request_id = fcrs1.priority_request_id

Line 4527: from pay_payroll_actions ppa,

4523: IF p_payroll_action_id is null then
4524: BEGIN
4525: SELECT payroll_action_id
4526: into l_payroll_action_id
4527: from pay_payroll_actions ppa,
4528: fnd_conc_req_summary_v fcrs,
4529: fnd_conc_req_summary_v fcrs1
4530: WHERE fcrs.request_id = fnd_global.conc_request_id
4531: and fcrs.priority_request_id = fcrs1.priority_request_id

Line 5529: from pay_payroll_actions ppa,

5525: IF p_payroll_action_id is null then
5526: BEGIN
5527: SELECT payroll_action_id
5528: into l_payroll_action_id
5529: from pay_payroll_actions ppa,
5530: fnd_conc_req_summary_v fcrs,
5531: fnd_conc_req_summary_v fcrs1
5532: WHERE fcrs.request_id = fnd_global.conc_request_id
5533: and fcrs.priority_request_id = fcrs1.priority_request_id

Line 6222: from pay_payroll_actions ppa,

6218: IF p_payroll_action_id is null then
6219: BEGIN
6220: SELECT payroll_action_id
6221: into l_payroll_action_id
6222: from pay_payroll_actions ppa,
6223: fnd_conc_req_summary_v fcrs,
6224: fnd_conc_req_summary_v fcrs1
6225: WHERE fcrs.request_id = fnd_global.conc_request_id
6226: and fcrs.priority_request_id = fcrs1.priority_request_id

Line 7011: from pay_payroll_actions ppa,

7007: IF p_payroll_action_id is null then
7008: BEGIN
7009: SELECT payroll_action_id
7010: into l_payroll_action_id
7011: from pay_payroll_actions ppa,
7012: fnd_conc_req_summary_v fcrs,
7013: fnd_conc_req_summary_v fcrs1
7014: WHERE fcrs.request_id = fnd_global.conc_request_id
7015: and fcrs.priority_request_id = fcrs1.priority_request_id