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_FI_ARCHIVE_PSTA dependencies on PER_ALL_ASSIGNMENTS_F

Line 377: per_all_assignments_f paaf,

373: pay_payroll_actions appa2,
374: pay_assignment_actions act,
375: pay_assignment_actions act1,
376: pay_action_interlocks pai,
377: per_all_assignments_f paaf,
378: hr_soft_coding_keyflex hsck,
379: hr_organization_information hoi,
380: pay_payrolls_f ppa
381: where appa.action_type in ('R', 'Q')

Line 440: assignment_id per_all_assignments_f.assignment_id%type,

436: person id,assignment id and the time period details for that person which it self a PL/SQL table */
437:
438: type per_period_detail_rec is record (
439: person_id per_all_people_f.person_id%type,
440: assignment_id per_all_assignments_f.assignment_id%type,
441: time_period benefit_time_period
442: );
443:
444: type person_period_detail is table of per_period_detail_rec

Line 524: from per_all_assignments_f asg1,

520: p_value_date date,
521: p_input_name varchar2
522: ) is
523: select iv1.name, eev1.effective_start_date, eev1.screen_entry_value screen_entry_value, iv1.lookup_type, uom
524: from per_all_assignments_f asg1,
525: per_all_assignments_f asg2,
526: per_all_people_f per,
527: pay_element_links_f el,
528: pay_element_types_f et,

Line 525: per_all_assignments_f asg2,

521: p_input_name varchar2
522: ) is
523: select iv1.name, eev1.effective_start_date, eev1.screen_entry_value screen_entry_value, iv1.lookup_type, uom
524: from per_all_assignments_f asg1,
525: per_all_assignments_f asg2,
526: per_all_people_f per,
527: pay_element_links_f el,
528: pay_element_types_f et,
529: pay_input_values_f iv1,

Line 1042: from per_all_assignments_f paaf, pay_assignment_actions paa

1038: l_tax_card_type varchar2 (200);
1039:
1040: /*Cursor csr_temination_date is
1041: select paaf.effective_start_date - 1 term_dt
1042: from per_all_assignments_f paaf, pay_assignment_actions paa
1043: where paaf.assignment_id = paa.assignment_id
1044: and paa.assignment_action_id = p_arch_assignment_action_id
1045: and assignment_status_type_id = (select assignment_status_type_id
1046: from per_assignment_status_types

Line 1059: from per_all_assignments_f paa

1055: p_start_date date,
1056: p_business_group_id number
1057: ) is
1058: select max (effective_end_date) effective_date
1059: from per_all_assignments_f paa
1060: where assignment_id = p_asg_id
1061: and paa.effective_start_date <= p_end_date
1062: and paa.effective_end_date > = p_start_date
1063: and assignment_status_type_id in (select assignment_status_type_id

Line 1076: from per_all_people_f papf, per_all_assignments_f paaf, pay_assignment_actions pac

1072: p_effective_date date
1073: ) is
1074: select papf.person_id person_id, paaf.assignment_id, national_identifier, full_name, employee_number,
1075: hourly_salaried_code, paaf.primary_flag, papf.date_of_birth, paaf.job_id, position_id
1076: from per_all_people_f papf, per_all_assignments_f paaf, pay_assignment_actions pac
1077: where pac.assignment_action_id = p_arch_assignment_action_id
1078: and paaf.assignment_id = pac.assignment_id
1079: and paaf.person_id = papf.person_id
1080: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date

Line 1090: from per_all_assignments_f asg1,

1086: p_input_value varchar2,
1087: p_value_date date
1088: ) is
1089: select eev1.screen_entry_value screen_entry_value
1090: from per_all_assignments_f asg1,
1091: per_all_assignments_f asg2,
1092: per_all_people_f per,
1093: pay_element_links_f el,
1094: pay_element_types_f et,

Line 1091: per_all_assignments_f asg2,

1087: p_value_date date
1088: ) is
1089: select eev1.screen_entry_value screen_entry_value
1090: from per_all_assignments_f asg1,
1091: per_all_assignments_f asg2,
1092: per_all_people_f per,
1093: pay_element_links_f el,
1094: pay_element_types_f et,
1095: pay_input_values_f iv1,

Line 1123: from per_all_assignments_f asg1,

1119: p_assignment_id number,
1120: p_value_date date
1121: ) is
1122: select iv1.name, eev1.effective_start_date, eev1.screen_entry_value screen_entry_value, iv1.lookup_type, uom
1123: from per_all_assignments_f asg1,
1124: per_all_assignments_f asg2,
1125: per_all_people_f per,
1126: pay_element_links_f el,
1127: pay_element_types_f et,

Line 1124: per_all_assignments_f asg2,

1120: p_value_date date
1121: ) is
1122: select iv1.name, eev1.effective_start_date, eev1.screen_entry_value screen_entry_value, iv1.lookup_type, uom
1123: from per_all_assignments_f asg1,
1124: per_all_assignments_f asg2,
1125: per_all_people_f per,
1126: pay_element_links_f el,
1127: pay_element_types_f et,
1128: pay_input_values_f iv1,

Line 1153: p_assignment_id per_all_assignments_f.assignment_id%type

1149: and p_value_date between ee.effective_start_date and ee.effective_end_date
1150: and p_value_date between eev1.effective_start_date and eev1.effective_end_date;
1151:
1152: cursor csr_get_benefit_type (
1153: p_assignment_id per_all_assignments_f.assignment_id%type
1154: ) is
1155: select pat.element_type_id, pat.element_name, pat.element_information1 benefit_type_code
1156: from pay_element_classifications pec, pay_element_types_f pat, pay_element_entries_f pet
1157: where pec.classification_name = 'Benefits in Kind'