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 1581: FROM per_people_f pap

1577: ,pap.per_information4 pan
1578: ,pap.per_information10 superannuation_number
1579: ,hr_in_utility.per_in_full_name(pap.first_name,pap.middle_names,pap.last_name,pap.title)
1580: ,pap.email_address
1581: FROM per_people_f pap
1582: WHERE pap.person_id = p_person_id
1583: AND p_date_earned BETWEEN pap.effective_start_date
1584: AND pap.effective_end_date;
1585:

Line 1688: l_pf_number per_people_f.per_information8%TYPE;

1684: l_emp_det_act_info_id NUMBER;
1685: l_tax_area VARCHAR2(10);
1686: l_dob VARCHAR2(30);
1687: /* Bug 4089704*/
1688: l_pf_number per_people_f.per_information8%TYPE;
1689: l_esi_number per_people_f.per_information9%TYPE;
1690: l_pan per_people_f.per_information4%TYPE;
1691: l_superannuation_number per_people_f.per_information10%TYPE;
1692: /* Bug 4089704*/

Line 1689: l_esi_number per_people_f.per_information9%TYPE;

1685: l_tax_area VARCHAR2(10);
1686: l_dob VARCHAR2(30);
1687: /* Bug 4089704*/
1688: l_pf_number per_people_f.per_information8%TYPE;
1689: l_esi_number per_people_f.per_information9%TYPE;
1690: l_pan per_people_f.per_information4%TYPE;
1691: l_superannuation_number per_people_f.per_information10%TYPE;
1692: /* Bug 4089704*/
1693:

Line 1690: l_pan per_people_f.per_information4%TYPE;

1686: l_dob VARCHAR2(30);
1687: /* Bug 4089704*/
1688: l_pf_number per_people_f.per_information8%TYPE;
1689: l_esi_number per_people_f.per_information9%TYPE;
1690: l_pan per_people_f.per_information4%TYPE;
1691: l_superannuation_number per_people_f.per_information10%TYPE;
1692: /* Bug 4089704*/
1693:
1694: l_month VARCHAR2(30);

Line 1691: l_superannuation_number per_people_f.per_information10%TYPE;

1687: /* Bug 4089704*/
1688: l_pf_number per_people_f.per_information8%TYPE;
1689: l_esi_number per_people_f.per_information9%TYPE;
1690: l_pan per_people_f.per_information4%TYPE;
1691: l_superannuation_number per_people_f.per_information10%TYPE;
1692: /* Bug 4089704*/
1693:
1694: l_month VARCHAR2(30);
1695: l_year VARCHAR2(30);

Line 1700: l_full_name per_people_f.full_name%TYPE;

1696: /* Bug 4159662*/
1697: l_reg_name hr_organization_units.name%TYPE;
1698: l_act_inf_id pay_action_information.action_information_id%TYPE;
1699: l_message VARCHAR2(255);
1700: l_full_name per_people_f.full_name%TYPE;
1701: l_email_address per_people_f.email_address%TYPE;
1702:
1703: --
1704: BEGIN

Line 1701: l_email_address per_people_f.email_address%TYPE;

1697: l_reg_name hr_organization_units.name%TYPE;
1698: l_act_inf_id pay_action_information.action_information_id%TYPE;
1699: l_message VARCHAR2(255);
1700: l_full_name per_people_f.full_name%TYPE;
1701: l_email_address per_people_f.email_address%TYPE;
1702:
1703: --
1704: BEGIN
1705: --

Line 1987: ,per_people_f pep

1983: ,con.contact_type -- added for ECR
1984: ,pep.sex -- added for ECR
1985: ,pep.date_of_birth -- added for ECR
1986: FROM per_assignments_f asg
1987: ,per_people_f pep
1988: ,pay_assignment_actions paa
1989: ,per_contact_relationships con
1990: WHERE asg.PERSON_ID=pep.person_id
1991: AND asg.assignment_id=paa.assignment_id

Line 2001: FROM per_people_f pea

1997:
1998: CURSOR csr_contact_details(p_contact_person_id NUMBER)
1999: IS
2000: SELECT hr_in_utility.per_in_full_name(pea.first_name,pea.middle_names,pea.last_name,pea.title) Father_Husbannd
2001: FROM per_people_f pea
2002: WHERE pea.person_id = p_contact_person_id
2003: AND p_payroll_date between pea.effective_start_date and pea.effective_end_date;
2004:
2005: -- Cursor to find PF Organization Id

Line 2071: FROM per_people_f ppf

2067: ,p_date DATE)
2068: IS
2069: SELECT ppf.per_information13 pension_num
2070: ,ppf.per_information8 PF_Number
2071: FROM per_people_f ppf
2072: ,per_assignments_f paf
2073: WHERE ppf.person_id = paf.person_id
2074: AND paf.assignment_id = p_assignment_id
2075: AND p_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date

Line 2084: FROM per_people_f ppf

2080: CURSOR csr_asg_pforg_start(l_person_id NUMBER
2081: ,l_source_id NUMBER)
2082: IS
2083: SELECT min(paf.effective_start_date)
2084: FROM per_people_f ppf
2085: ,per_assignments_f paf
2086: ,hr_soft_coding_keyflex scl
2087: WHERE ppf.person_id = l_person_id
2088: AND paf.person_id =ppf.person_id

Line 2098: FROM per_people_f ppf

2094: ,l_source_id NUMBER
2095: ,l_asg_start_date varchar2)
2096: IS
2097: SELECT '1'
2098: FROM per_people_f ppf
2099: ,per_assignments_f paf
2100: ,hr_soft_coding_keyflex scl
2101: WHERE ppf.person_id = l_person_id
2102: AND paf.person_id =ppf.person_id

Line 2115: FROM per_people_f ppf

2111: CURSOR csr_chk_pension_number_change(l_person_id NUMBER
2112: ,l_asg_start_date varchar2)
2113: IS
2114: SELECT ppf.per_information13
2115: FROM per_people_f ppf
2116: WHERE ppf.person_id =l_person_id
2117: AND ppf.per_information13 IS NOT NULL
2118: AND ppf.effective_start_date < l_asg_start_date
2119: ORDER BY ppf.effective_start_date desc;

Line 2129: FROM per_people_f ppf

2125: SELECT MAX(pos.date_start)
2126: FROM per_periods_of_service pos
2127: WHERE pos.person_id = p_person_id
2128: AND pos.date_start <= (SELECT MIN(effective_start_date)
2129: FROM per_people_f ppf
2130: WHERE ppf.person_id = p_person_id
2131: AND ppf.per_information13 = p_pension_number);
2132:
2133: -- Bug 4033745 End

Line 2143: FROM per_people_f ppf,

2139: SELECT
2140: distinct
2141: pps.actual_termination_date term_date, -- Termination Date
2142: pps.pds_information3 efile -- Termination Reason(EFile)
2143: FROM per_people_f ppf,
2144: per_assignments_f paf,
2145: per_periods_of_service pps,
2146: hr_soft_coding_keyflex scl
2147: WHERE paf.person_id = ppf.person_id

Line 2172: l_full_name per_people_f.full_name%TYPE;

2168: l_epf_diff NUMBER;
2169: l_contribution_rate NUMBER;
2170: l_absence NUMBER;
2171: l_contr_period VARCHAR2(10);
2172: l_full_name per_people_f.full_name%TYPE;
2173: l_pf_number per_people_f.per_information8%TYPE;
2174: l_fh_hus per_people_f.full_name%TYPE;
2175: l_source_id hr_organization_units.organization_id%TYPE;
2176: l_pf_org_name hr_organization_units.name%TYPE;

Line 2173: l_pf_number per_people_f.per_information8%TYPE;

2169: l_contribution_rate NUMBER;
2170: l_absence NUMBER;
2171: l_contr_period VARCHAR2(10);
2172: l_full_name per_people_f.full_name%TYPE;
2173: l_pf_number per_people_f.per_information8%TYPE;
2174: l_fh_hus per_people_f.full_name%TYPE;
2175: l_source_id hr_organization_units.organization_id%TYPE;
2176: l_pf_org_name hr_organization_units.name%TYPE;
2177: l_pension_num per_people_f.per_information13%TYPE;

Line 2174: l_fh_hus per_people_f.full_name%TYPE;

2170: l_absence NUMBER;
2171: l_contr_period VARCHAR2(10);
2172: l_full_name per_people_f.full_name%TYPE;
2173: l_pf_number per_people_f.per_information8%TYPE;
2174: l_fh_hus per_people_f.full_name%TYPE;
2175: l_source_id hr_organization_units.organization_id%TYPE;
2176: l_pf_org_name hr_organization_units.name%TYPE;
2177: l_pension_num per_people_f.per_information13%TYPE;
2178: flag BOOLEAN;

Line 2177: l_pension_num per_people_f.per_information13%TYPE;

2173: l_pf_number per_people_f.per_information8%TYPE;
2174: l_fh_hus per_people_f.full_name%TYPE;
2175: l_source_id hr_organization_units.organization_id%TYPE;
2176: l_pf_org_name hr_organization_units.name%TYPE;
2177: l_pension_num per_people_f.per_information13%TYPE;
2178: flag BOOLEAN;
2179: l_start_date DATE;
2180: l_end_date DATE;
2181: l_person_id NUMBER;

Line 2183: l_exists per_people_f.per_information13%TYPE;

2179: l_start_date DATE;
2180: l_end_date DATE;
2181: l_person_id NUMBER;
2182: l_asg_start_date VARCHAR2(30);
2183: l_exists per_people_f.per_information13%TYPE;
2184: l_pf_comp_salary NUMBER;
2185: l_pf_ytd NUMBER;
2186: l_excluded_employee_status NUMBER;
2187: l_contact_id NUMBER;

Line 2191: l_sex per_people_f.sex%TYPE;

2187: l_contact_id NUMBER;
2188: l_procedure VARCHAR2(100);
2189: l_message VARCHAR2(255);
2190: l_contact_type per_contact_relationships.contact_type%TYPE;
2191: l_sex per_people_f.sex%TYPE;
2192: l_dob VARCHAR2(30);
2193: l_eps_wages NUMBER;
2194: l_term_date VARCHAR2(30);
2195: l_reason VARCHAR2(30);

Line 2687: ,per_people_f pep

2683: SELECT hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) Employee_Name
2684: ,pep.per_information9 ESI_Number
2685: ,pep.person_id person_id
2686: FROM per_assignments_f asg
2687: ,per_people_f pep
2688: ,pay_assignment_actions paa
2689: WHERE asg.PERSON_ID=pep.person_id
2690: AND asg.assignment_id=paa.assignment_id
2691: AND paa.assignment_action_id= p_assignment_action_id

Line 2765: FROM per_people_f

2761: CURSOR c_death_date(p_person_id NUMBER
2762: ,p_effective_date DATE)
2763: IS
2764: SELECT '1'
2765: FROM per_people_f
2766: WHERE person_id= p_person_id
2767: AND date_of_death <= p_effective_date ;
2768:
2769: --Cursor to find termination status

Line 2803: FROM per_people_f ppf

2799: CURSOR csr_esi_number(p_assigment_id NUMBER
2800: ,p_date DATE)
2801: IS
2802: SELECT ppf.per_information9 ESI_Number
2803: FROM per_people_f ppf
2804: ,per_assignments_f paf
2805: WHERE ppf.person_id = paf.person_id
2806: AND paf.assignment_id = p_assignment_id
2807: AND p_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date

Line 2844: l_full_name per_people_f.full_name%TYPE;

2840: l_employee_contribution NUMBER;
2841: l_employer_contribution NUMBER;
2842: l_absence NUMBER;
2843: l_contr_period VARCHAR2(30);
2844: l_full_name per_people_f.full_name%TYPE;
2845: l_person_id per_people_f.person_id%TYPE;
2846: l_esi_number per_people_f.per_information9%TYPE;
2847: l_source_id hr_organization_units.organization_id%TYPE;
2848: l_esi_org_name hr_organization_units.name%TYPE;

Line 2845: l_person_id per_people_f.person_id%TYPE;

2841: l_employer_contribution NUMBER;
2842: l_absence NUMBER;
2843: l_contr_period VARCHAR2(30);
2844: l_full_name per_people_f.full_name%TYPE;
2845: l_person_id per_people_f.person_id%TYPE;
2846: l_esi_number per_people_f.per_information9%TYPE;
2847: l_source_id hr_organization_units.organization_id%TYPE;
2848: l_esi_org_name hr_organization_units.name%TYPE;
2849: flag BOOLEAN;

Line 2846: l_esi_number per_people_f.per_information9%TYPE;

2842: l_absence NUMBER;
2843: l_contr_period VARCHAR2(30);
2844: l_full_name per_people_f.full_name%TYPE;
2845: l_person_id per_people_f.person_id%TYPE;
2846: l_esi_number per_people_f.per_information9%TYPE;
2847: l_source_id hr_organization_units.organization_id%TYPE;
2848: l_esi_org_name hr_organization_units.name%TYPE;
2849: flag BOOLEAN;
2850: l_reason_for_exem VARCHAR2(60);

Line 3338: ,per_people_f peap

3334: IS
3335: SELECT DISTINCT hr_in_utility.per_in_full_name(peap.first_name,peap.middle_names,peap.last_name,peap.title) rep_name
3336: ,peap.person_id person_id
3337: FROM hr_organization_information hoi
3338: ,per_people_f peap
3339: WHERE hoi.ORGANIZATION_ID=p_pf_org_id
3340: AND hoi.ORG_INFORMATION_CONTEXT = DECODE (p_context,'PF','PER_IN_PF_REP_DF','ESI','PER_IN_ESI_REP_DF')
3341: AND peap.person_id=hoi.ORG_INFORMATION1
3342: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2)

Line 3395: l_org_rep_name per_people_f.full_name%TYPE;

3391: AND action_information1 = p_contribution_period
3392: AND action_information2 = p_organization_id
3393: AND action_context_type = 'PA';
3394:
3395: l_org_rep_name per_people_f.full_name%TYPE;
3396: l_reg_name hr_organization_units.name%TYPE;
3397: l_code hr_organization_information.org_information1%TYPE;
3398: l_org_name hr_organization_units.name%TYPE;
3399: l_address VARCHAR2(240);

Line 3668: ,per_people_f pep

3664: IS
3665: SELECT hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) Employee_Name
3666: ,pep.person_id person_id
3667: FROM per_assignments_f asg
3668: ,per_people_f pep
3669: ,pay_assignment_actions paa
3670: WHERE asg.person_id = pep.person_id
3671: AND asg.assignment_id = paa.assignment_id
3672: AND paa.assignment_action_id = p_assignment_action_id

Line 3733: l_full_name per_people_f.full_name%TYPE;

3729: l_contrib_month VARCHAR2(20);
3730: l_contrib_year VARCHAR2(20);
3731: l_start_date DATE;
3732: l_end_date DATE;
3733: l_full_name per_people_f.full_name%TYPE;
3734: l_person_id per_people_f.person_id%TYPE;
3735: l_source_id hr_organization_units.organization_id%TYPE;
3736: l_pt_org_name hr_organization_units.name%TYPE;
3737: l_element_type_id pay_element_types_f.element_type_id%TYPE;

Line 3734: l_person_id per_people_f.person_id%TYPE;

3730: l_contrib_year VARCHAR2(20);
3731: l_start_date DATE;
3732: l_end_date DATE;
3733: l_full_name per_people_f.full_name%TYPE;
3734: l_person_id per_people_f.person_id%TYPE;
3735: l_source_id hr_organization_units.organization_id%TYPE;
3736: l_pt_org_name hr_organization_units.name%TYPE;
3737: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3738: l_state_iv_id pay_input_values_f.input_value_id%TYPE;

Line 4032: ,per_people_f peap

4028: IS
4029: SELECT DISTINCT hr_in_utility.per_in_full_name(peap.first_name,peap.middle_names,peap.last_name,peap.title) rep_name
4030: ,peap.person_id person_id
4031: FROM hr_organization_information hoi
4032: ,per_people_f peap
4033: WHERE hoi.organization_id = p_pf_org_id
4034: AND hoi.org_information_context = 'PER_IN_PROF_TAX_REP_DF'
4035: AND peap.person_id = hoi.org_information1
4036: AND p_effective_date BETWEEN fnd_date.canonical_to_date(hoi.org_information2)

Line 4072: l_org_rep_name per_people_f.full_name%TYPE;

4068: l_effective_date DATE;
4069: l_reg_name hr_organization_units.name%TYPE;
4070: l_reg_no hr_organization_information.org_information1%TYPE;
4071: l_org_name hr_organization_units.name%TYPE;
4072: l_org_rep_name per_people_f.full_name%TYPE;
4073: l_rep_person_id per_people_f.person_id%TYPE;
4074: l_org_id hr_organization_units.organization_id%TYPE;
4075: l_source_id hr_organization_units.organization_id%TYPE;
4076: l_message VARCHAR2(255);

Line 4073: l_rep_person_id per_people_f.person_id%TYPE;

4069: l_reg_name hr_organization_units.name%TYPE;
4070: l_reg_no hr_organization_information.org_information1%TYPE;
4071: l_org_name hr_organization_units.name%TYPE;
4072: l_org_rep_name per_people_f.full_name%TYPE;
4073: l_rep_person_id per_people_f.person_id%TYPE;
4074: l_org_id hr_organization_units.organization_id%TYPE;
4075: l_source_id hr_organization_units.organization_id%TYPE;
4076: l_message VARCHAR2(255);
4077: l_procedure VARCHAR2(100);