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

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

131: p_parameter_string IN VARCHAR2
132: ,p_token IN VARCHAR2
133: ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2
134: IS
135: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
136: l_start_pos NUMBER;
137: l_delimiter VARCHAR2(1):=' ';
138: l_proc VARCHAR2(40):= g_package||' get parameter ';
139: BEGIN

Line 208: FROM pay_payroll_actions

204: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'COMPANY_TERMINATING')
205: ,PAY_DK_ARCHIVE_EHOL.GET_PARAMETER(legislative_parameters,'MESSAGE_TEXT')
206: ,effective_date
207: ,business_group_id
208: FROM pay_payroll_actions
209: WHERE payroll_action_id = p_payroll_action_id;
210:
211: l_proc VARCHAR2(240):= g_package||' GET_ALL_PARAMETERS ';
212: --

Line 390: pay_payroll_actions

386: Cursor cur_report_type IS
387: select
388: report_type
389: from
390: pay_payroll_actions
391: where payroll_action_id = p_payroll_action_id;
392:
393: l_report_type VARCHAR2(100);
394:

Line 419: p_sql := 'SELECT DISTINCT person_id FROM per_people_f ppf,pay_payroll_actions ppa WHERE ppa.payroll_action_id = :payroll_action_id AND ppa.business_group_id = ppf.business_group_id ORDER BY ppf.person_id';

415: IF g_debug THEN
416: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
417: END IF;
418:
419: p_sql := 'SELECT DISTINCT person_id FROM per_people_f ppf,pay_payroll_actions ppa WHERE ppa.payroll_action_id = :payroll_action_id AND ppa.business_group_id = ppf.business_group_id ORDER BY ppf.person_id';
420:
421: g_legal_employer_id := NULL ;
422: g_effective_date := NULL ;
423: g_start_date := NULL;

Line 633: p_sql := 'SELECT DISTINCT person_id FROM per_people_f ppf,pay_payroll_actions ppa WHERE 1=2';

629: END IF; --end l_count condition
630:
631:
632: IF l_errflag_uhc = 'Y' THEN
633: p_sql := 'SELECT DISTINCT person_id FROM per_people_f ppf,pay_payroll_actions ppa WHERE 1=2';
634: Raise l_ehc_exception;
635: END IF;
636:
637: IF g_debug THEN

Line 685: FROM pay_payroll_actions ppa

681: --act.assignment_action_id run_action_id,
682: act1.assignment_action_id prepaid_action_id,
683: as1.hourly_salaried_code
684: ,as1.payroll_id
685: FROM pay_payroll_actions ppa
686: ,pay_payroll_actions appa
687: ,pay_payroll_actions appa2
688: ,pay_assignment_actions act
689: ,pay_assignment_actions act1

Line 686: ,pay_payroll_actions appa

682: act1.assignment_action_id prepaid_action_id,
683: as1.hourly_salaried_code
684: ,as1.payroll_id
685: FROM pay_payroll_actions ppa
686: ,pay_payroll_actions appa
687: ,pay_payroll_actions appa2
688: ,pay_assignment_actions act
689: ,pay_assignment_actions act1
690: ,pay_action_interlocks pai

Line 687: ,pay_payroll_actions appa2

683: as1.hourly_salaried_code
684: ,as1.payroll_id
685: FROM pay_payroll_actions ppa
686: ,pay_payroll_actions appa
687: ,pay_payroll_actions appa2
688: ,pay_assignment_actions act
689: ,pay_assignment_actions act1
690: ,pay_action_interlocks pai
691: ,per_all_assignments_f as1

Line 735: pay_payroll_actions

731: Cursor cur_report_type IS
732: select
733: report_type
734: from
735: pay_payroll_actions
736: where payroll_action_id = p_payroll_action_id;
737:
738: l_report_type VARCHAR2(100);
739:

Line 1265: (select 1 from pay_payroll_actions ppa, pay_assignment_actions paa

1261: AND ptp.end_date BETWEEN c_canonical_start_date AND c_canonical_end_date
1262: AND ppf.business_group_id = g_business_group_id
1263: AND ptp.end_date between paf.effective_start_date and paf.effective_end_date
1264: and exists
1265: (select 1 from pay_payroll_actions ppa, pay_assignment_actions paa
1266: where ppa.payroll_action_id = paa.payroll_action_id
1267: and ppa.action_type IN ('R','Q')
1268: AND ppa.effective_date between c_canonical_start_date and c_canonical_end_date
1269: AND paa.assignment_id = paf.assignment_id

Line 1394: from pay_assignment_actions pac, pay_payroll_actions ppa

1390: lr_Get_Defined_Balance_Id csr_Get_Defined_Balance_Id%rowtype;
1391:
1392: CURSOR csr_asg_action_id(assg_id NUMBER, pid NUMBER, tid NUMBER, le_id NUMBER) IS
1393: select MAX(pac.ASSIGNMENT_ACTION_ID) id
1394: from pay_assignment_actions pac, pay_payroll_actions ppa
1395: where ppa.action_type IN ('R','Q')
1396: and pac.payroll_action_id = ppa.payroll_action_id
1397: and pac.assignment_id= assg_id
1398: and ppa.payroll_id=pid

Line 1421: FROM pay_payroll_actions ppa

1417: l_canonical_end_date DATE,
1418: l_assignment_id NUMBER)
1419: IS
1420: SELECT 1
1421: FROM pay_payroll_actions ppa
1422: ,pay_payroll_actions appa
1423: ,pay_payroll_actions appa2
1424: ,pay_assignment_actions act
1425: ,pay_assignment_actions act1

Line 1422: ,pay_payroll_actions appa

1418: l_assignment_id NUMBER)
1419: IS
1420: SELECT 1
1421: FROM pay_payroll_actions ppa
1422: ,pay_payroll_actions appa
1423: ,pay_payroll_actions appa2
1424: ,pay_assignment_actions act
1425: ,pay_assignment_actions act1
1426: ,pay_action_interlocks pai

Line 1423: ,pay_payroll_actions appa2

1419: IS
1420: SELECT 1
1421: FROM pay_payroll_actions ppa
1422: ,pay_payroll_actions appa
1423: ,pay_payroll_actions appa2
1424: ,pay_assignment_actions act
1425: ,pay_assignment_actions act1
1426: ,pay_action_interlocks pai
1427: ,per_all_assignments_f as1

Line 1468: pay_payroll_actions ppa

1464:
1465: CURSOR cur_max_asg_act_id(p_assignment_id NUMBER, p_start_date DATE, p_end_date DATE) IS
1466: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id
1467: FROM pay_assignment_actions paa,
1468: pay_payroll_actions ppa
1469: WHERE ppa.payroll_action_id = paa.payroll_action_id
1470: and paa.assignment_id = p_assignment_id
1471: and ppa.action_type in ('R','Q','I','B','V')
1472: and paa.source_action_id is null

Line 1477: FROM pay_payroll_actions ppa

1473: AND ppa.effective_date between p_start_date AND p_end_date;
1474:
1475: CURSOR cur_table_val_exist_400(p_payroll_action_id number) IS
1476: SELECT 'Y'
1477: FROM pay_payroll_actions ppa
1478: , pay_user_tables put
1479: , pay_user_columns puc
1480: , pay_user_column_instances_f puci
1481: , pay_user_rows_f pur

Line 1766: pay_payroll_actions

1762: Cursor cur_report_type(p_payroll_action_id NUMBER) IS
1763: select
1764: report_type
1765: from
1766: pay_payroll_actions
1767: where payroll_action_id = p_payroll_action_id;
1768:
1769: l_report_type VARCHAR2(100);
1770:

Line 1924: (select 1 from pay_payroll_actions ppa, pay_assignment_actions paa

1920: ptp.start_date and ptp.end_date)'
1921: ||' AND ppf.business_group_id = ' || g_business_group_id ||
1922: ' AND (ptp.end_date between paf.effective_start_date and paf.effective_end_date OR ptp.start_date between paf.effective_start_date and paf.effective_end_date )
1923: and exists
1924: (select 1 from pay_payroll_actions ppa, pay_assignment_actions paa
1925: where ppa.payroll_action_id = paa.payroll_action_id
1926: and ppa.action_type IN ('||''''||'R'||''''||','||''''||'Q'||''''|| ') '
1927: ||' AND ppa.effective_date between '||''''|| l_canonical_start_date ||''''||' and ' ||''''|| l_canonical_end_date ||''''
1928: ||' AND paa.assignment_id = paf.assignment_id

Line 1936: pay_payroll_actions ppa,

1932: */
1933:
1934: l_select_qry := l_select_str
1935: ||' FROM
1936: pay_payroll_actions ppa,
1937: pay_assignment_actions paa
1938: where ppa.payroll_action_id = paa.payroll_action_id
1939: and ppa.action_type IN ('||''''||'R'||''''||','||''''||'Q'||''''|| ') '
1940: ||' AND ppa.effective_date between '||''''|| l_canonical_start_date ||''''||' and ' ||''''|| l_canonical_end_date ||''''

Line 3241: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is

3237: RAISE;
3238: END ARCHIVE_CODE;
3239:
3240: PROCEDURE DEINITIALIZATION_CODE
3241: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
3242: BEGIN
3243: fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE START 1');
3244: IF l_errflag = 'Y' THEN
3245: Fnd_file.put_line(FND_FILE.LOG,'Process completed with warning(s). Please check the output file.' );

Line 3421: pay_payroll_actions

3417: Cursor cur_report_type IS
3418: select
3419: report_type
3420: from
3421: pay_payroll_actions
3422: where payroll_action_id = p_payroll_act_id;
3423:
3424: l_report_type VARCHAR2(100);
3425: