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

Line 12: g_param_assignment_id per_all_assignments_f.assignment_id%TYPE;

8: -- Parameters to the process - g_payroll_action_id is the cache context
9: --
10: g_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
11: g_param_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
12: g_param_assignment_id per_all_assignments_f.assignment_id%TYPE;
13: g_param_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
14: g_param_business_group_id per_business_Groups.business_group_id%TYPE;
15: g_param_start_date date;
16: g_param_effective_date date;

Line 199: FROM per_all_assignments_f asg

195: cursor csr_assignments (p_stperson number, p_endperson number) IS
196: SELECT pre_assact.assignment_action_id assignment_action_id
197: ,pre_assact.assignment_id assignment_id
198: ,pre_assact.tax_unit_id establishment_id
199: FROM per_all_assignments_f asg
200: ,pay_assignment_actions pre_assact
201: ,pay_payroll_actions pre_payact
202: WHERE asg.person_id between p_stperson and p_endperson
203: and asg.period_of_service_id is not null

Line 587: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

583: ,p_effective_date in date) is
584: --
585: l_establishment_id pay_assignment_actions.tax_unit_id%TYPE;
586: l_person_id per_all_people_f.person_id%TYPE;
587: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
588: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
589: l_latest_assignment_action_id pay_assignment_actions.assignment_id%TYPE;
590: l_latest_date_paid date;
591: l_ee_asat_date date;

Line 1214: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

1210: ,p_payroll_id out nocopy number) is
1211: --
1212: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
1213: l_person_id per_all_people_f.person_id%TYPE;
1214: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1215: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
1216: --
1217: l_proc VARCHAR2(40):= g_package||' get_instance_variables ';
1218: cursor csr_establishment(p_paa_id number) is

Line 1364: from per_all_assignments_f asg1

1360: -- csr_estab_start_date Gets the employees estab start dates
1361: --
1362: cursor csr_ee_estab_start_date (p_assignment_id number, p_date_earned date, p_establishment_id number) is
1363: select min(asg1.effective_start_date)
1364: from per_all_assignments_f asg1
1365: ,per_all_assignments_f asg2
1366: where asg1.assignment_id = p_assignment_id
1367: and asg2.assignment_id = p_assignment_id
1368: and asg1.establishment_id = asg2.establishment_id

Line 1365: ,per_all_assignments_f asg2

1361: --
1362: cursor csr_ee_estab_start_date (p_assignment_id number, p_date_earned date, p_establishment_id number) is
1363: select min(asg1.effective_start_date)
1364: from per_all_assignments_f asg1
1365: ,per_all_assignments_f asg2
1366: where asg1.assignment_id = p_assignment_id
1367: and asg2.assignment_id = p_assignment_id
1368: and asg1.establishment_id = asg2.establishment_id
1369: and asg2.effective_start_date >= asg1.effective_start_date

Line 1372: from per_all_assignments_f asg

1368: and asg1.establishment_id = asg2.establishment_id
1369: and asg2.effective_start_date >= asg1.effective_start_date
1370: and not exists /* no in between row with different estab id */
1371: (select null
1372: from per_all_assignments_f asg
1373: where asg.effective_start_date > asg1.effective_end_Date
1374: and asg.effective_end_date < asg2.effective_start_date
1375: and asg.establishment_id <> asg1.establishment_id
1376: and asg.assignment_id = asg1.assignment_id)

Line 1379: from per_all_assignments_f

1375: and asg.establishment_id <> asg1.establishment_id
1376: and asg.assignment_id = asg1.assignment_id)
1377: and asg2.effective_start_date =
1378: (select max(effective_Start_Date)
1379: from per_all_assignments_f
1380: where assignment_id = p_assignment_id
1381: and establishment_id = p_establishment_id
1382: and effective_Start_Date <= p_date_earned);
1383:

Line 1389: from per_all_assignments_f asg3

1385: -- csr_estab_end_date Gets the employees estab end dates
1386: --
1387: cursor csr_ee_estab_end_date (p_assignment_id number, p_date_earned date, p_establishment_id number) is
1388: select max(asg4.effective_end_date)
1389: from per_all_assignments_f asg3
1390: ,per_all_assignments_f asg4
1391: where asg3.assignment_id = p_assignment_id
1392: and asg4.assignment_id = p_assignment_id
1393: and asg3.establishment_id = asg4.establishment_id

Line 1390: ,per_all_assignments_f asg4

1386: --
1387: cursor csr_ee_estab_end_date (p_assignment_id number, p_date_earned date, p_establishment_id number) is
1388: select max(asg4.effective_end_date)
1389: from per_all_assignments_f asg3
1390: ,per_all_assignments_f asg4
1391: where asg3.assignment_id = p_assignment_id
1392: and asg4.assignment_id = p_assignment_id
1393: and asg3.establishment_id = asg4.establishment_id
1394: and asg4.effective_start_date >= asg3.effective_start_date

Line 1397: from per_all_assignments_f asg

1393: and asg3.establishment_id = asg4.establishment_id
1394: and asg4.effective_start_date >= asg3.effective_start_date
1395: and not exists /* no in between row with different estab id */
1396: (select null
1397: from per_all_assignments_f asg
1398: where asg.effective_start_date < asg4.effective_start_Date
1399: and asg.effective_start_date > asg3.effective_start_date
1400: and asg.establishment_id <> asg4.establishment_id
1401: and asg.assignment_id = asg4.assignment_id)

Line 1404: from per_all_assignments_f

1400: and asg.establishment_id <> asg4.establishment_id
1401: and asg.assignment_id = asg4.assignment_id)
1402: and asg4.effective_start_date =
1403: (select max(effective_Start_Date)
1404: from per_all_assignments_f
1405: where assignment_id = p_assignment_id
1406: and establishment_id = p_establishment_id
1407: and effective_Start_Date <= p_date_earned);
1408:

Line 1459: ,per_all_assignments_f asg

1455: ,hr_general.decode_lookup('LEAV_REAS', svc.leaving_reason)
1456: ,svc.pds_information11 final_pay_schedule
1457: ,fnd_date.canonical_to_date(svc.pds_information10) LWD
1458: from per_periods_of_service svc
1459: ,per_all_assignments_f asg
1460: where asg.period_of_service_id = svc.period_of_service_id
1461: and p_effective_date between asg.effective_start_date and asg.effective_end_date
1462: and asg.assignment_id = p_assignment_id;
1463: --

Line 1599: l_ee_payroll_id per_all_assignments_f.payroll_id%TYPE;

1595: l_ee_job_definition_id per_jobs.job_definition_id%type;
1596: l_ee_position_name per_positions.name%TYPE;
1597: l_ee_coll_agree_name per_collective_agreements.name%TYPE;
1598: l_ee_coy_id varchar2(150);
1599: l_ee_payroll_id per_all_assignments_f.payroll_id%TYPE;
1600: l_ee_maiden_name per_all_people_f.previous_last_name%TYPE;
1601: l_ee_assignment_number per_all_assignments_f.assignment_number%TYPE;
1602: l_ee_org_name hr_all_organization_units.name%TYPE;
1603: --

Line 1601: l_ee_assignment_number per_all_assignments_f.assignment_number%TYPE;

1597: l_ee_coll_agree_name per_collective_agreements.name%TYPE;
1598: l_ee_coy_id varchar2(150);
1599: l_ee_payroll_id per_all_assignments_f.payroll_id%TYPE;
1600: l_ee_maiden_name per_all_people_f.previous_last_name%TYPE;
1601: l_ee_assignment_number per_all_assignments_f.assignment_number%TYPE;
1602: l_ee_org_name hr_all_organization_units.name%TYPE;
1603: --
1604: NO_ADDRESS EXCEPTION; /* error as must be sent to a home address */
1605: --

Line 1665: per_all_assignments_f asg

1661: ,hrl.meaning Con_Unit_mean
1662: ,ctr.ctr_information13 Con_Frequency
1663: ,hrl1.meaning Con_freq_mean
1664: from
1665: per_all_assignments_f asg
1666: ,per_all_people_f peo
1667: ,per_jobs job
1668: ,hr_all_positions_f_tl postl
1669: ,per_collective_agreements cag

Line 1737: per_all_assignments_f asg

1733: ,'SEGMENT18', CAGR.segment18
1734: ,'SEGMENT19', CAGR.segment19
1735: ,'SEGMENT20', CAGR.segment20, null),1,60) seg_value
1736: from
1737: per_all_assignments_f asg
1738: ,per_cagr_grades_def cagr
1739: ,fnd_id_flex_segments seg
1740: ,fnd_id_flex_segments_tl seg_tl
1741: ,fnd_segment_attribute_values gqual