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.PER_JP_EMPDET_REPORT_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 597: ,pay_assignment_actions PAA

593: initialize(p_payroll_action_id);
594:
595: sqlstr := ' SELECT PAA.rowid
596: FROM per_assignments_f PAF
597: ,pay_assignment_actions PAA
598: ,per_people_f PPF
599: ,hr_all_organization_units HAOU
600: ,per_periods_of_service PPS
601: WHERE PAA.payroll_action_id = :pactid

Line 691: ,pay_assignment_actions PAA

687: initialize(p_payroll_action_id);
688:
689: sqlstr := ' SELECT PAA.rowid
690: FROM per_assignments_f PAF
691: ,pay_assignment_actions PAA
692: ,per_people_f PPF
693: ,hr_all_organization_units_tl HAOUT
694: ,hr_all_organization_units HAOU
695: ,per_periods_of_service PPS

Line 848: ,pay_assignment_actions PAS

844: SELECT PJEDV.assignment_id
845: ,PJEDV.effective_date
846: FROM per_assignments_f PAA
847: ,per_people_f PAP
848: ,pay_assignment_actions PAS
849: ,per_jp_empdet_emp_v PJEDV
850: ,per_periods_of_service PPOF
851: ,pay_population_ranges PPR
852: ,pay_payroll_actions PPA

Line 902: ,pay_assignment_actions PAS

898: SELECT PJEDV.assignment_id
899: ,PJEDV.effective_date
900: FROM per_assignments_f PAA
901: ,per_people_f PAP
902: ,pay_assignment_actions PAS
903: ,per_periods_of_service PPS
904: ,per_jp_empdet_emp_v PJEDV
905: WHERE PAA.person_id = PAP.person_id
906: AND PAA.person_id BETWEEN p_start_person_id

Line 942: ln_assact pay_assignment_actions.assignment_action_id%TYPE ;

938: AND PJEDV.terminate_flag = 'C'
939: )
940: );
941: --
942: ln_assact pay_assignment_actions.assignment_action_id%TYPE ;
943: lt_org_id per_jp_report_common_pkg.gt_org_tbl;
944: lc_proc_name VARCHAR2(60);
945: lc_legislative_parameters VARCHAR2(2000);
946: lc_result1 VARCHAR2(30);

Line 1028: SELECT pay_assignment_actions_s.nextval

1024: --
1025: -- Added NVL to overcome NULL issue.
1026: IF (NVL(ln_ass_set_id,0) = 0) THEN
1027: -- NO assignment set passed as parameter
1028: SELECT pay_assignment_actions_s.nextval
1029: INTO ln_assact
1030: FROM dual;
1031: hr_nonrun_asact.insact(ln_assact
1032: ,lr_assact.assignment_id

Line 1044: SELECT pay_assignment_actions_s.nextval

1040: ,p_assignment_id => lr_assact.assignment_id
1041: ,p_effective_date => gr_parameters.effective_date
1042: );
1043: IF lc_include_flag = 'Y' THEN
1044: SELECT pay_assignment_actions_s.nextval
1045: INTO ln_assact
1046: FROM dual;
1047: hr_nonrun_asact.insact(ln_assact
1048: ,lr_assact.assignment_id

Line 1075: SELECT pay_assignment_actions_s.nextval

1071: --
1072: -- Added NVL to overcome NULL issue.
1073: IF (NVL(ln_ass_set_id,0) = 0) THEN
1074: -- NO assignment set passed as parameter
1075: SELECT pay_assignment_actions_s.nextval
1076: INTO ln_assact
1077: FROM dual;
1078: hr_nonrun_asact.insact(ln_assact
1079: ,lr_assact.assignment_id

Line 1091: SELECT pay_assignment_actions_s.nextval

1087: ,p_assignment_id => lr_assact.assignment_id
1088: ,p_effective_date => gr_parameters.effective_date
1089: );
1090: IF lc_include_flag = 'Y' THEN
1091: SELECT pay_assignment_actions_s.nextval
1092: INTO ln_assact
1093: FROM dual;
1094: hr_nonrun_asact.insact(ln_assact
1095: ,lr_assact.assignment_id

Line 1129: SELECT pay_assignment_actions_s.nextval

1125: -- Added NVL to overcome NULL issue.
1126: IF (NVL(ln_ass_set_id,0) = 0) THEN
1127: --
1128: -- NO assignment set passed as parameter
1129: SELECT pay_assignment_actions_s.nextval
1130: INTO ln_assact
1131: FROM dual;
1132: hr_nonrun_asact.insact(ln_assact
1133: ,lr_assact.assignment_id

Line 1145: SELECT pay_assignment_actions_s.nextval

1141: ,p_assignment_id => lr_assact.assignment_id
1142: ,p_effective_date => gr_parameters.effective_date
1143: );
1144: IF lc_include_flag = 'Y' THEN
1145: SELECT pay_assignment_actions_s.nextval
1146: INTO ln_assact
1147: FROM dual;
1148: hr_nonrun_asact.insact(ln_assact
1149: ,lr_assact.assignment_id

Line 1180: SELECT pay_assignment_actions_s.nextval

1176: -- Added NVL to overcome NULL issue.
1177: IF (NVL(ln_ass_set_id,0) = 0) THEN
1178: --
1179: -- NO assignment set passed as parameter
1180: SELECT pay_assignment_actions_s.nextval
1181: INTO ln_assact
1182: FROM dual;
1183: hr_nonrun_asact.insact(ln_assact
1184: ,lr_assact.assignment_id

Line 1196: SELECT pay_assignment_actions_s.nextval

1192: ,p_assignment_id => lr_assact.assignment_id
1193: ,p_effective_date => gr_parameters.effective_date
1194: );
1195: IF lc_include_flag = 'Y' THEN
1196: SELECT pay_assignment_actions_s.nextval
1197: INTO ln_assact
1198: FROM dual;
1199: hr_nonrun_asact.insact(ln_assact
1200: ,lr_assact.assignment_id

Line 1477: ln_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

1473: lr_emp_det lcu_emp_det%ROWTYPE;
1474: lr_proc_info lcu_proc_info%ROWTYPE;
1475: lr_emp_add_info lcu_emp_add_info%ROWTYPE;
1476: --Local Variables
1477: ln_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1478: lblob_image per_images.image%TYPE;
1479: lc_xml CLOB;
1480: lc_xml2 CLOB;
1481: lc_common_xml CLOB;

Line 1986: FROM pay_assignment_actions PAA

1982: ln_pact_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('PACTID',lc_legislative_parameters));
1983: --
1984: SELECT PAA1.assignment_action_id
1985: INTO ln_old_assact_id
1986: FROM pay_assignment_actions PAA
1987: ,pay_assignment_actions PAA1
1988: WHERE PAA.assignment_action_id = ln_cur_assact
1989: AND PAA.assignment_id = PAA1.assignment_id
1990: AND PAA1.payroll_action_id = ln_pact_id;

Line 1987: ,pay_assignment_actions PAA1

1983: --
1984: SELECT PAA1.assignment_action_id
1985: INTO ln_old_assact_id
1986: FROM pay_assignment_actions PAA
1987: ,pay_assignment_actions PAA1
1988: WHERE PAA.assignment_action_id = ln_cur_assact
1989: AND PAA.assignment_id = PAA1.assignment_id
1990: AND PAA1.payroll_action_id = ln_pact_id;
1991: --