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

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

208: p_parameter_string IN VARCHAR2
209: ,p_token IN VARCHAR2
210: ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2
211: IS
212: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
213: l_start_pos NUMBER;
214: l_delimiter VARCHAR2(1):=' ';
215: l_proc VARCHAR2(40):= g_package||' get parameter ';
216: BEGIN

Line 267: FROM pay_payroll_actions

263: ,effective_date
264: ,business_group_id
265: ,PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'REPORT_TYPE') -- Bug#9579261 fix
266: ,PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'EMPLOYEE_NAME') -- 14260836
267: FROM pay_payroll_actions
268: WHERE payroll_action_id = p_payroll_action_id;
269: --
270: l_proc VARCHAR2(240):= g_package||' GET_ALL_PARAMETERS ';
271: --

Line 441: FROM pay_payroll_actions ppa

437: p_legal_employer_id NUMBER,
438: l_start_date DATE,
439: l_end_date DATE) IS
440: SELECT DISTINCT act.assignment_id assignment_id
441: FROM pay_payroll_actions ppa
442: ,pay_payroll_actions appa
443: ,pay_payroll_actions appa2
444: ,pay_assignment_actions act
445: ,pay_assignment_actions act1

Line 442: ,pay_payroll_actions appa

438: l_start_date DATE,
439: l_end_date DATE) IS
440: SELECT DISTINCT act.assignment_id assignment_id
441: FROM pay_payroll_actions ppa
442: ,pay_payroll_actions appa
443: ,pay_payroll_actions appa2
444: ,pay_assignment_actions act
445: ,pay_assignment_actions act1
446: ,pay_action_interlocks pai

Line 443: ,pay_payroll_actions appa2

439: l_end_date DATE) IS
440: SELECT DISTINCT act.assignment_id assignment_id
441: FROM pay_payroll_actions ppa
442: ,pay_payroll_actions appa
443: ,pay_payroll_actions appa2
444: ,pay_assignment_actions act
445: ,pay_assignment_actions act1
446: ,pay_action_interlocks pai
447: ,per_all_assignments_f as1

Line 495: FROM pay_payroll_actions ppa

491: ,l_start_date DATE
492: ,l_end_date DATE
493: ,p_employee_id NUMBER) IS --14260836
494: SELECT DISTINCT act.assignment_id assignment_id
495: FROM pay_payroll_actions ppa
496: ,pay_payroll_actions appa
497: ,pay_payroll_actions appa2
498: ,pay_assignment_actions act
499: ,pay_assignment_actions act1

Line 496: ,pay_payroll_actions appa

492: ,l_end_date DATE
493: ,p_employee_id NUMBER) IS --14260836
494: SELECT DISTINCT act.assignment_id assignment_id
495: FROM pay_payroll_actions ppa
496: ,pay_payroll_actions appa
497: ,pay_payroll_actions appa2
498: ,pay_assignment_actions act
499: ,pay_assignment_actions act1
500: ,pay_action_interlocks pai

Line 497: ,pay_payroll_actions appa2

493: ,p_employee_id NUMBER) IS --14260836
494: SELECT DISTINCT act.assignment_id assignment_id
495: FROM pay_payroll_actions ppa
496: ,pay_payroll_actions appa
497: ,pay_payroll_actions appa2
498: ,pay_assignment_actions act
499: ,pay_assignment_actions act1
500: ,pay_action_interlocks pai
501: ,per_all_assignments_f as1

Line 533: pay_payroll_actions ppa,

529: p_local_unit_id NUMBER,
530: p_legal_employer_id NUMBER) IS
531: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id
532: FROM pay_assignment_actions paa,
533: pay_payroll_actions ppa,
534: per_all_assignments_f paaf,
535: hr_soft_coding_keyflex hsck
536: WHERE ppa.payroll_action_id = paa.payroll_action_id
537: and paa.assignment_id = paaf.assignment_id

Line 735: ,pay_payroll_actions ppa

731: END IF;
732: --
733: p_sql :='SELECT DISTINCT person_id
734: FROM per_people_f ppf
735: ,pay_payroll_actions ppa
736: WHERE ppa.payroll_action_id = :payroll_action_id
737: AND ppa.business_group_id = ppf.business_group_id
738: ORDER BY ppf.person_id';
739: --

Line 1597: from pay_payroll_actions ppa,

1593: IF p_payroll_action_id is null then
1594: BEGIN
1595: SELECT payroll_action_id
1596: into l_payroll_action_id
1597: from pay_payroll_actions ppa,
1598: fnd_conc_req_summary_v fcrs,
1599: fnd_conc_req_summary_v fcrs1
1600: WHERE fcrs.request_id = fnd_global.conc_request_id
1601: and fcrs.priority_request_id = fcrs1.priority_request_id

Line 2257: from pay_payroll_actions ppa,

2253: IF p_payroll_action_id is null then
2254: BEGIN
2255: SELECT payroll_action_id
2256: into l_payroll_action_id
2257: from pay_payroll_actions ppa,
2258: fnd_conc_req_summary_v fcrs,
2259: fnd_conc_req_summary_v fcrs1
2260: WHERE fcrs.request_id = fnd_global.conc_request_id
2261: and fcrs.priority_request_id = fcrs1.priority_request_id