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_IN_PAYSLIP_ARCHIVE dependencies on PER_ASSIGNMENTS_F

Line 1439: FROM per_assignments_f paa

1435:
1436: CURSOR csr_person_id
1437: IS
1438: SELECT paa.person_id
1439: FROM per_assignments_f paa
1440: WHERE paa.assignment_id = p_assignment_id
1441: AND p_date_earned BETWEEN paa.effective_start_date
1442: AND paa.effective_end_date;
1443: --

Line 1465: ,per_assignments_f paaf

1461: --
1462: SELECT hoi.org_information1
1463: FROM hr_soft_coding_keyflex hsck
1464: ,hr_organization_information hoi
1465: ,per_assignments_f paaf
1466: ,pay_assignment_actions paa
1467: ,pay_payroll_actions ppa
1468: WHERE paa.assignment_action_id = p_assactid
1469: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1528: FROM per_assignments_f peaf

1524: -- Cursor to get the Registered Name of the GRE/Legal Entity
1525: Cursor c_reg_name
1526: IS
1527: SELECT hou.name
1528: FROM per_assignments_f peaf
1529: ,hr_soft_coding_keyflex hrscf
1530: ,hr_organization_information hoi
1531: ,hr_organization_units hou
1532: WHERE peaf.assignment_id=p_assignment_id

Line 1540: l_person_id per_assignments_f.person_id%TYPE;

1536: AND hou.organization_id=hoi.org_information4
1537: AND p_date_earned between peaf.effective_start_date and peaf.effective_end_date;
1538: --
1539: --
1540: l_person_id per_assignments_f.person_id%TYPE;
1541:
1542: l_action_info_id NUMBER;
1543: l_ovn NUMBER;
1544: l_tax_unit_id NUMBER;

Line 1837: FROM per_assignments_f asg

1833: ,pep.per_information8 PF_Number
1834: ,pep.per_information13 Pension_Number
1835: ,pep.person_id person_id
1836: ,con.contact_person_id contact
1837: FROM per_assignments_f asg
1838: ,per_people_f pep
1839: ,pay_assignment_actions paa
1840: ,per_contact_relationships con
1841: WHERE asg.PERSON_ID=pep.person_id

Line 1862: ,per_assignments_f asg

1858: IS
1859: select DISTINCT hoi.organization_id source_id
1860: from hr_organization_units hoi
1861: ,hr_soft_coding_keyflex scf
1862: ,per_assignments_f asg
1863: ,pay_assignment_actions paa
1864: where asg.assignment_id=paa.assignment_id
1865: and paa.assignment_action_id=p_assignment_action_id
1866: and asg.SOFT_CODING_KEYFLEX_ID=scf.SOFT_CODING_KEYFLEX_ID

Line 1907: FROM per_assignments_f paf

1903: ,p_pay_start DATE
1904: ,p_pay_end DATE)
1905: IS
1906: SELECT MAX(paf.effective_end_date)
1907: FROM per_assignments_f paf
1908: ,hr_soft_coding_keyflex scl
1909: WHERE paf.soft_coding_keyflex_id=scl.soft_coding_keyflex_id
1910: AND paf.assignment_id=p_assignment_id
1911: AND scl.segment2 = p_source_id

Line 1923: ,per_assignments_f paf

1919: IS
1920: SELECT ppf.per_information13 pension_num
1921: ,ppf.per_information8 PF_Number
1922: FROM per_people_f ppf
1923: ,per_assignments_f paf
1924: WHERE ppf.person_id = paf.person_id
1925: AND paf.assignment_id = p_assignment_id
1926: AND p_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
1927: AND p_date BETWEEN paf.effective_start_date AND paf.effective_end_date;

Line 1936: ,per_assignments_f paf

1932: ,l_source_id NUMBER)
1933: IS
1934: SELECT min(paf.effective_start_date)
1935: FROM per_people_f ppf
1936: ,per_assignments_f paf
1937: ,hr_soft_coding_keyflex scl
1938: WHERE ppf.person_id = l_person_id
1939: AND paf.person_id =ppf.person_id
1940: AND paf.soft_coding_keyflex_id =scl.soft_coding_keyflex_id

Line 1950: ,per_assignments_f paf

1946: ,l_asg_start_date varchar2)
1947: IS
1948: SELECT '1'
1949: FROM per_people_f ppf
1950: ,per_assignments_f paf
1951: ,hr_soft_coding_keyflex scl
1952: WHERE ppf.person_id = l_person_id
1953: AND paf.person_id =ppf.person_id
1954: AND paf.soft_coding_keyflex_id =scl.soft_coding_keyflex_id

Line 2445: ,per_assignments_f asg

2441: IS
2442: SELECT DISTINCT hoi.organization_id source_id
2443: FROM hr_organization_units hoi
2444: ,hr_soft_coding_keyflex scf
2445: ,per_assignments_f asg
2446: ,pay_assignment_actions paa
2447: WHERE asg.assignment_id=paa.assignment_id
2448: AND paa.assignment_action_id=p_assignment_action_id
2449: AND asg.SOFT_CODING_KEYFLEX_ID=scf.SOFT_CODING_KEYFLEX_ID

Line 2474: FROM per_assignments_f asg

2470: IS
2471: SELECT hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) Employee_Name
2472: ,pep.per_information9 ESI_Number
2473: ,pep.person_id person_id
2474: FROM per_assignments_f asg
2475: ,per_people_f pep
2476: ,pay_assignment_actions paa
2477: WHERE asg.PERSON_ID=pep.person_id
2478: AND asg.assignment_id=paa.assignment_id

Line 2578: FROM per_assignments_f paf

2574: ,p_pay_start DATE
2575: ,p_pay_end DATE)
2576: IS
2577: SELECT MAX(paf.effective_end_date)
2578: FROM per_assignments_f paf
2579: ,hr_soft_coding_keyflex scl
2580: WHERE paf.soft_coding_keyflex_id=scl.soft_coding_keyflex_id
2581: AND paf.assignment_id=p_assignment_id
2582: AND scl.segment4 = p_source_id

Line 2592: ,per_assignments_f paf

2588: ,p_date DATE)
2589: IS
2590: SELECT ppf.per_information9 ESI_Number
2591: FROM per_people_f ppf
2592: ,per_assignments_f paf
2593: WHERE ppf.person_id = paf.person_id
2594: AND paf.assignment_id = p_assignment_id
2595: AND p_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
2596: AND p_date BETWEEN paf.effective_start_date AND paf.effective_end_date;

Line 3158: ,per_assignments_f asg

3154: ,p_effective_date DATE)
3155: IS
3156: SELECT nvl(pos.name,job.name) name
3157: FROM per_positions pos
3158: ,per_assignments_f asg
3159: ,per_jobs job
3160: WHERE asg.position_id=pos.position_id(+)
3161: AND asg.job_id=job.job_id(+)
3162: AND asg.person_id = p_person_id

Line 3408: ,per_assignments_f asg

3404: IS
3405: SELECT DISTINCT pay_in_prof_tax_pkg.get_state(hoi.organization_id) jurisdiction_code
3406: FROM hr_organization_units hoi
3407: ,hr_soft_coding_keyflex scf
3408: ,per_assignments_f asg
3409: ,pay_assignment_actions paa
3410: WHERE asg.assignment_id = paa.assignment_id
3411: AND paa.assignment_action_id = p_assignment_action_id
3412: AND asg.soft_coding_keyflex_id = scf.soft_coding_keyflex_id

Line 3429: ,per_assignments_f asg

3425: ,hoi.name name
3426: ,asg.effective_end_date
3427: FROM hr_organization_units hoi
3428: ,hr_soft_coding_keyflex scf
3429: ,per_assignments_f asg
3430: ,pay_assignment_actions paa
3431: WHERE asg.assignment_id = paa.assignment_id
3432: AND paa.assignment_action_id = p_assignment_action_id
3433: AND asg.soft_coding_keyflex_id = scf.soft_coding_keyflex_id

Line 3447: FROM per_assignments_f asg

3443: CURSOR c_person_full_name(p_assignment_action_id NUMBER)
3444: IS
3445: SELECT hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) Employee_Name
3446: ,pep.person_id person_id
3447: FROM per_assignments_f asg
3448: ,per_people_f pep
3449: ,pay_assignment_actions paa
3450: WHERE asg.person_id = pep.person_id
3451: AND asg.assignment_id = paa.assignment_id

Line 3520: l_asg_id per_assignments_f.assignment_id%TYPE;

3516: l_pt_org_name hr_organization_units.name%TYPE;
3517: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3518: l_state_iv_id pay_input_values_f.input_value_id%TYPE;
3519: l_reason_iv_id pay_input_values_f.input_value_id%TYPE;
3520: l_asg_id per_assignments_f.assignment_id%TYPE;
3521: l_message VARCHAR2(255);
3522: l_procedure VARCHAR2(100);
3523:
3524: -- Added as a part of bug fix 4774108.

Line 3826: ,per_assignments_f asg

3822: ,p_effective_date DATE)
3823: IS
3824: SELECT nvl(pos.name,job.name) name
3825: FROM per_positions pos
3826: ,per_assignments_f asg
3827: ,per_jobs job
3828: WHERE asg.position_id=pos.position_id(+)
3829: AND asg.job_id=job.job_id(+)
3830: AND asg.person_id = p_person_id