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 337: l_parameter pay_payroll_actions.legislative_parameters%TYPE := NULL;

333: FUNCTION get_parameter
334: (p_parameter_string IN VARCHAR2
335: ,p_token IN VARCHAR) RETURN VARCHAR2 IS
336: --
337: l_parameter pay_payroll_actions.legislative_parameters%TYPE := NULL;
338: l_start_pos NUMBER;
339: l_delimiter VARCHAR2(1) := ' ';
340: --
341: BEGIN

Line 924: FROM pay_payroll_actions

920: SELECT business_group_id
921: ,legislative_parameters
922: ,pay_no_eoy_archive.get_parameter(legislative_parameters, 'LEGAL_EMPLOYER_ID') legal_employer_id
923: ,fnd_date.canonical_to_date(pay_no_eoy_archive.get_parameter(legislative_parameters, 'DATE')) report_date
924: FROM pay_payroll_actions
925: WHERE payroll_action_id = p_payroll_action_id;
926: --
927: l_parameter_rec csr_PARAMS%ROWTYPE;
928: --

Line 1101: ,pay_payroll_actions ppa

1097: -- ,TO_NUMBER(SUBSTR(lu.meaning, 1,1)) ni_zone
1098: ,DECODE(orginf2.org_information5,'Y', orginf2.org_information2,orginf1.org_information4) nace_code -- 2007/08 changes
1099: ,paa.assignment_id assg_id -- 2007/2008 Changes
1100: FROM pay_assignment_actions paa
1101: ,pay_payroll_actions ppa
1102: ,pay_action_contexts pac1
1103: ,pay_action_contexts pac2
1104: ,ff_contexts ctx1
1105: ,ff_contexts ctx2

Line 1143: FROM pay_payroll_actions ppa

1139: ,p_business_group_id IN NUMBER
1140: ,p_legal_employer_id IN NUMBER
1141: ,p_assg_id IN NUMBER) IS
1142: SELECT max(paa.assignment_action_id)
1143: FROM pay_payroll_actions ppa
1144: ,pay_assignment_actions paa
1145: WHERE ppa.business_group_id = p_business_group_id
1146: AND ppa.action_type IN ('R','Q','I','B')
1147: AND ppa.action_status = 'C'

Line 1596: ,pay_payroll_actions ppa

1592: --
1593: p_sql :=
1594: 'SELECT DISTINCT per.person_id
1595: FROM per_people_f per
1596: ,pay_payroll_actions ppa
1597: WHERE ppa.payroll_action_id = :payroll_action_id
1598: AND per.business_group_id = ppa.business_group_id
1599: ORDER BY per.person_id';
1600: --

Line 1634: ,pay_payroll_actions ppa

1630: ,MAX(asg.effective_end_date) effective_end_date
1631: ,MAX(asg.effective_start_date) effective_start_date --Changes 2007/2008
1632: FROM per_all_assignments_f asg
1633: ,pay_assignment_actions paa
1634: ,pay_payroll_actions ppa
1635: ,pay_action_information ai
1636: ,pay_action_contexts ac1
1637: ,ff_contexts ctx1
1638: ,pay_action_contexts ac2

Line 1933: ,pay_payroll_actions ppa

1929: ,pay_action_contexts ac1
1930: ,ff_contexts ctx1
1931: ,pay_action_contexts ac2
1932: ,ff_contexts ctx2
1933: ,pay_payroll_actions ppa
1934: ,pay_run_results rr
1935: ,pay_run_result_values rrv
1936: ,pay_input_values_f pivf
1937: ,pay_user_tables t

Line 2049: ,pay_payroll_actions ppa

2045: ,pay_action_contexts ac1
2046: ,ff_contexts ctx1
2047: ,pay_action_contexts ac2
2048: ,ff_contexts ctx2
2049: ,pay_payroll_actions ppa
2050: ,pay_run_results rr
2051: ,pay_run_result_values rrv
2052: ,pay_input_values_f pivf
2053: ,pay_element_types_f petf

Line 2110: ,pay_payroll_actions ppa

2106: ,pay_action_contexts ac1
2107: ,ff_contexts ctx1
2108: ,pay_action_contexts ac2
2109: ,ff_contexts ctx2
2110: ,pay_payroll_actions ppa
2111: ,pay_run_results rr
2112: ,pay_run_result_values rrv
2113: ,pay_input_values_f pivf
2114: ,pay_element_types_f petf

Line 3170: from pay_payroll_actions ppa,

3166: IF p_payroll_action_id is null then
3167: BEGIN
3168: SELECT payroll_action_id
3169: into l_payroll_action_id
3170: from pay_payroll_actions ppa,
3171: fnd_conc_req_summary_v fcrs,
3172: fnd_conc_req_summary_v fcrs1
3173: WHERE fcrs.request_id = fnd_global.conc_request_id
3174: and fcrs.priority_request_id = fcrs1.priority_request_id

Line 3779: from pay_payroll_actions ppa,

3775: IF p_payroll_action_id is null then
3776: BEGIN
3777: SELECT payroll_action_id
3778: into l_payroll_action_id
3779: from pay_payroll_actions ppa,
3780: fnd_conc_req_summary_v fcrs,
3781: fnd_conc_req_summary_v fcrs1
3782: WHERE fcrs.request_id = fnd_global.conc_request_id
3783: and fcrs.priority_request_id = fcrs1.priority_request_id

Line 4609: from pay_payroll_actions ppa,

4605: IF p_payroll_action_id is null then
4606: BEGIN
4607: SELECT payroll_action_id
4608: into l_payroll_action_id
4609: from pay_payroll_actions ppa,
4610: fnd_conc_req_summary_v fcrs,
4611: fnd_conc_req_summary_v fcrs1
4612: WHERE fcrs.request_id = fnd_global.conc_request_id
4613: and fcrs.priority_request_id = fcrs1.priority_request_id

Line 5237: from pay_payroll_actions ppa,

5233: IF p_payroll_action_id is null then
5234: BEGIN
5235: SELECT payroll_action_id
5236: into l_payroll_action_id
5237: from pay_payroll_actions ppa,
5238: fnd_conc_req_summary_v fcrs,
5239: fnd_conc_req_summary_v fcrs1
5240: WHERE fcrs.request_id = fnd_global.conc_request_id
5241: and fcrs.priority_request_id = fcrs1.priority_request_id

Line 5894: from pay_payroll_actions ppa,

5890: IF p_payroll_action_id is null then
5891: BEGIN
5892: SELECT payroll_action_id
5893: into l_payroll_action_id
5894: from pay_payroll_actions ppa,
5895: fnd_conc_req_summary_v fcrs,
5896: fnd_conc_req_summary_v fcrs1
5897: WHERE fcrs.request_id = fnd_global.conc_request_id
5898: and fcrs.priority_request_id = fcrs1.priority_request_id