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_PEOPLE_F

Line 1452: FROM per_people_f pap

1448: ,pap.per_information9 esi_number
1449: ,pap.per_information4 pan
1450: ,pap.per_information10 superannuation_number
1451: ,hr_in_utility.per_in_full_name(pap.first_name,pap.middle_names,pap.last_name,pap.title)
1452: FROM per_people_f pap
1453: WHERE pap.person_id = p_person_id
1454: AND p_date_earned BETWEEN pap.effective_start_date
1455: AND pap.effective_end_date;
1456:

Line 1559: l_pf_number per_people_f.per_information8%TYPE;

1555: l_emp_det_act_info_id NUMBER;
1556: l_tax_area VARCHAR2(10);
1557: l_dob VARCHAR2(30);
1558: /* Bug 4089704*/
1559: l_pf_number per_people_f.per_information8%TYPE;
1560: l_esi_number per_people_f.per_information9%TYPE;
1561: l_pan per_people_f.per_information4%TYPE;
1562: l_superannuation_number per_people_f.per_information10%TYPE;
1563: /* Bug 4089704*/

Line 1560: l_esi_number per_people_f.per_information9%TYPE;

1556: l_tax_area VARCHAR2(10);
1557: l_dob VARCHAR2(30);
1558: /* Bug 4089704*/
1559: l_pf_number per_people_f.per_information8%TYPE;
1560: l_esi_number per_people_f.per_information9%TYPE;
1561: l_pan per_people_f.per_information4%TYPE;
1562: l_superannuation_number per_people_f.per_information10%TYPE;
1563: /* Bug 4089704*/
1564:

Line 1561: l_pan per_people_f.per_information4%TYPE;

1557: l_dob VARCHAR2(30);
1558: /* Bug 4089704*/
1559: l_pf_number per_people_f.per_information8%TYPE;
1560: l_esi_number per_people_f.per_information9%TYPE;
1561: l_pan per_people_f.per_information4%TYPE;
1562: l_superannuation_number per_people_f.per_information10%TYPE;
1563: /* Bug 4089704*/
1564:
1565: l_month VARCHAR2(30);

Line 1562: l_superannuation_number per_people_f.per_information10%TYPE;

1558: /* Bug 4089704*/
1559: l_pf_number per_people_f.per_information8%TYPE;
1560: l_esi_number per_people_f.per_information9%TYPE;
1561: l_pan per_people_f.per_information4%TYPE;
1562: l_superannuation_number per_people_f.per_information10%TYPE;
1563: /* Bug 4089704*/
1564:
1565: l_month VARCHAR2(30);
1566: l_year VARCHAR2(30);

Line 1571: l_full_name per_people_f.full_name%TYPE;

1567: /* Bug 4159662*/
1568: l_reg_name hr_organization_units.name%TYPE;
1569: l_act_inf_id pay_action_information.action_information_id%TYPE;
1570: l_message VARCHAR2(255);
1571: l_full_name per_people_f.full_name%TYPE;
1572:
1573: --
1574: BEGIN
1575: --

Line 1838: ,per_people_f pep

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
1842: AND asg.assignment_id=paa.assignment_id

Line 1852: FROM per_people_f pea

1848:
1849: CURSOR csr_contact_details(p_contact_person_id NUMBER)
1850: IS
1851: SELECT hr_in_utility.per_in_full_name(pea.first_name,pea.middle_names,pea.last_name,pea.title) Father_Husbannd
1852: FROM per_people_f pea
1853: WHERE pea.person_id = p_contact_person_id
1854: AND p_payroll_date between pea.effective_start_date and pea.effective_end_date;
1855:
1856: -- Cursor to find PF Organization Id

Line 1922: FROM per_people_f ppf

1918: ,p_date DATE)
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

Line 1935: FROM per_people_f ppf

1931: CURSOR csr_asg_pforg_start(l_person_id NUMBER
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

Line 1949: FROM per_people_f ppf

1945: ,l_source_id NUMBER
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

Line 1966: FROM per_people_f ppf

1962: CURSOR csr_chk_pension_number_change(l_person_id NUMBER
1963: ,l_asg_start_date varchar2)
1964: IS
1965: SELECT ppf.per_information13
1966: FROM per_people_f ppf
1967: WHERE ppf.person_id =l_person_id
1968: AND ppf.per_information13 IS NOT NULL
1969: AND ppf.effective_start_date < l_asg_start_date
1970: ORDER BY ppf.effective_start_date desc;

Line 1980: FROM per_people_f ppf

1976: SELECT MAX(pos.date_start)
1977: FROM per_periods_of_service pos
1978: WHERE pos.person_id = p_person_id
1979: AND pos.date_start <= (SELECT MIN(effective_start_date)
1980: FROM per_people_f ppf
1981: WHERE ppf.person_id = p_person_id
1982: AND ppf.per_information13 = p_pension_number);
1983:
1984: -- Bug 4033745 End

Line 2001: l_full_name per_people_f.full_name%TYPE;

1997: l_epf_diff NUMBER;
1998: l_contribution_rate NUMBER;
1999: l_absence NUMBER;
2000: l_contr_period VARCHAR2(10);
2001: l_full_name per_people_f.full_name%TYPE;
2002: l_pf_number per_people_f.per_information8%TYPE;
2003: l_fh_hus per_people_f.full_name%TYPE;
2004: l_source_id hr_organization_units.organization_id%TYPE;
2005: l_pf_org_name hr_organization_units.name%TYPE;

Line 2002: l_pf_number per_people_f.per_information8%TYPE;

1998: l_contribution_rate NUMBER;
1999: l_absence NUMBER;
2000: l_contr_period VARCHAR2(10);
2001: l_full_name per_people_f.full_name%TYPE;
2002: l_pf_number per_people_f.per_information8%TYPE;
2003: l_fh_hus per_people_f.full_name%TYPE;
2004: l_source_id hr_organization_units.organization_id%TYPE;
2005: l_pf_org_name hr_organization_units.name%TYPE;
2006: l_pension_num per_people_f.per_information13%TYPE;

Line 2003: l_fh_hus per_people_f.full_name%TYPE;

1999: l_absence NUMBER;
2000: l_contr_period VARCHAR2(10);
2001: l_full_name per_people_f.full_name%TYPE;
2002: l_pf_number per_people_f.per_information8%TYPE;
2003: l_fh_hus per_people_f.full_name%TYPE;
2004: l_source_id hr_organization_units.organization_id%TYPE;
2005: l_pf_org_name hr_organization_units.name%TYPE;
2006: l_pension_num per_people_f.per_information13%TYPE;
2007: flag BOOLEAN;

Line 2006: l_pension_num per_people_f.per_information13%TYPE;

2002: l_pf_number per_people_f.per_information8%TYPE;
2003: l_fh_hus per_people_f.full_name%TYPE;
2004: l_source_id hr_organization_units.organization_id%TYPE;
2005: l_pf_org_name hr_organization_units.name%TYPE;
2006: l_pension_num per_people_f.per_information13%TYPE;
2007: flag BOOLEAN;
2008: l_start_date DATE;
2009: l_end_date DATE;
2010: l_person_id NUMBER;

Line 2012: l_exists per_people_f.per_information13%TYPE;

2008: l_start_date DATE;
2009: l_end_date DATE;
2010: l_person_id NUMBER;
2011: l_asg_start_date VARCHAR2(30);
2012: l_exists per_people_f.per_information13%TYPE;
2013: l_pf_comp_salary NUMBER;
2014: l_pf_ytd NUMBER;
2015: l_excluded_employee_status NUMBER;
2016: l_contact_id NUMBER;

Line 2475: ,per_people_f pep

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
2479: AND paa.assignment_action_id= p_assignment_action_id

Line 2553: FROM per_people_f

2549: CURSOR c_death_date(p_person_id NUMBER
2550: ,p_effective_date DATE)
2551: IS
2552: SELECT '1'
2553: FROM per_people_f
2554: WHERE person_id= p_person_id
2555: AND date_of_death <= p_effective_date ;
2556:
2557: --Cursor to find termination status

Line 2591: FROM per_people_f ppf

2587: CURSOR csr_esi_number(p_assigment_id NUMBER
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

Line 2632: l_full_name per_people_f.full_name%TYPE;

2628: l_employee_contribution NUMBER;
2629: l_employer_contribution NUMBER;
2630: l_absence NUMBER;
2631: l_contr_period VARCHAR2(30);
2632: l_full_name per_people_f.full_name%TYPE;
2633: l_person_id per_people_f.person_id%TYPE;
2634: l_esi_number per_people_f.per_information9%TYPE;
2635: l_source_id hr_organization_units.organization_id%TYPE;
2636: l_esi_org_name hr_organization_units.name%TYPE;

Line 2633: l_person_id per_people_f.person_id%TYPE;

2629: l_employer_contribution NUMBER;
2630: l_absence NUMBER;
2631: l_contr_period VARCHAR2(30);
2632: l_full_name per_people_f.full_name%TYPE;
2633: l_person_id per_people_f.person_id%TYPE;
2634: l_esi_number per_people_f.per_information9%TYPE;
2635: l_source_id hr_organization_units.organization_id%TYPE;
2636: l_esi_org_name hr_organization_units.name%TYPE;
2637: flag BOOLEAN;

Line 2634: l_esi_number per_people_f.per_information9%TYPE;

2630: l_absence NUMBER;
2631: l_contr_period VARCHAR2(30);
2632: l_full_name per_people_f.full_name%TYPE;
2633: l_person_id per_people_f.person_id%TYPE;
2634: l_esi_number per_people_f.per_information9%TYPE;
2635: l_source_id hr_organization_units.organization_id%TYPE;
2636: l_esi_org_name hr_organization_units.name%TYPE;
2637: flag BOOLEAN;
2638: l_reason_for_exem VARCHAR2(60);

Line 3126: ,per_people_f peap

3122: IS
3123: SELECT DISTINCT hr_in_utility.per_in_full_name(peap.first_name,peap.middle_names,peap.last_name,peap.title) rep_name
3124: ,peap.person_id person_id
3125: FROM hr_organization_information hoi
3126: ,per_people_f peap
3127: WHERE hoi.ORGANIZATION_ID=p_pf_org_id
3128: AND hoi.ORG_INFORMATION_CONTEXT = DECODE (p_context,'PF','PER_IN_PF_REP_DF','ESI','PER_IN_ESI_REP_DF')
3129: AND peap.person_id=hoi.ORG_INFORMATION1
3130: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2)

Line 3183: l_org_rep_name per_people_f.full_name%TYPE;

3179: AND action_information1 = p_contribution_period
3180: AND action_information2 = p_organization_id
3181: AND action_context_type = 'PA';
3182:
3183: l_org_rep_name per_people_f.full_name%TYPE;
3184: l_reg_name hr_organization_units.name%TYPE;
3185: l_code hr_organization_information.org_information1%TYPE;
3186: l_org_name hr_organization_units.name%TYPE;
3187: l_address VARCHAR2(240);

Line 3448: ,per_people_f pep

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
3452: AND paa.assignment_action_id = p_assignment_action_id

Line 3513: l_full_name per_people_f.full_name%TYPE;

3509: l_contrib_month VARCHAR2(20);
3510: l_contrib_year VARCHAR2(20);
3511: l_start_date DATE;
3512: l_end_date DATE;
3513: l_full_name per_people_f.full_name%TYPE;
3514: l_person_id per_people_f.person_id%TYPE;
3515: l_source_id hr_organization_units.organization_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;

Line 3514: l_person_id per_people_f.person_id%TYPE;

3510: l_contrib_year VARCHAR2(20);
3511: l_start_date DATE;
3512: l_end_date DATE;
3513: l_full_name per_people_f.full_name%TYPE;
3514: l_person_id per_people_f.person_id%TYPE;
3515: l_source_id hr_organization_units.organization_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;

Line 3812: ,per_people_f peap

3808: IS
3809: SELECT DISTINCT hr_in_utility.per_in_full_name(peap.first_name,peap.middle_names,peap.last_name,peap.title) rep_name
3810: ,peap.person_id person_id
3811: FROM hr_organization_information hoi
3812: ,per_people_f peap
3813: WHERE hoi.organization_id = p_pf_org_id
3814: AND hoi.org_information_context = 'PER_IN_PROF_TAX_REP_DF'
3815: AND peap.person_id = hoi.org_information1
3816: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2)

Line 3852: l_org_rep_name per_people_f.full_name%TYPE;

3848: l_effective_date DATE;
3849: l_reg_name hr_organization_units.name%TYPE;
3850: l_reg_no hr_organization_information.org_information1%TYPE;
3851: l_org_name hr_organization_units.name%TYPE;
3852: l_org_rep_name per_people_f.full_name%TYPE;
3853: l_rep_person_id per_people_f.person_id%TYPE;
3854: l_org_id hr_organization_units.organization_id%TYPE;
3855: l_source_id hr_organization_units.organization_id%TYPE;
3856: l_message VARCHAR2(255);

Line 3853: l_rep_person_id per_people_f.person_id%TYPE;

3849: l_reg_name hr_organization_units.name%TYPE;
3850: l_reg_no hr_organization_information.org_information1%TYPE;
3851: l_org_name hr_organization_units.name%TYPE;
3852: l_org_rep_name per_people_f.full_name%TYPE;
3853: l_rep_person_id per_people_f.person_id%TYPE;
3854: l_org_id hr_organization_units.organization_id%TYPE;
3855: l_source_id hr_organization_units.organization_id%TYPE;
3856: l_message VARCHAR2(255);
3857: l_procedure VARCHAR2(100);