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.

[Home] [Help]

APPS.PAY_US_WEB_W4 dependencies on PER_PEOPLE_F

Line 710: FUNCTION check_update_status(p_person_id IN per_people_f.person_id%TYPE)

706: END IF; -- State Following Federal Or NOT
707: hr_utility.trace('g_nonmatch_cntr := '||g_nonmatch_cntr);
708: END Fed_State_Filing_Status_Match;
709:
710: FUNCTION check_update_status(p_person_id IN per_people_f.person_id%TYPE)
711: RETURN VARCHAR2
712: /******************************************************************
713: **
714: ** Description:

Line 927: ln_person_id per_people_f.person_id%TYPE;

923: l_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
924: l_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
925: l_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
926: l_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
927: ln_person_id per_people_f.person_id%TYPE;
928: ln_business_group_id per_people_f.business_group_id%TYPE;
929: ln_organization_id hr_organization_information.organization_id%TYPE;
930: lr_org_info_rec hr_organization_information%ROWTYPE;
931: -- lrr_item_rec pay_us_misc_web.item_attr_rec;

Line 928: ln_business_group_id per_people_f.business_group_id%TYPE;

924: l_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
925: l_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
926: l_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
927: ln_person_id per_people_f.person_id%TYPE;
928: ln_business_group_id per_people_f.business_group_id%TYPE;
929: ln_organization_id hr_organization_information.organization_id%TYPE;
930: lr_org_info_rec hr_organization_information%ROWTYPE;
931: -- lrr_item_rec pay_us_misc_web.item_attr_rec;
932: lv_has_errors VARCHAR2(1) := 'N';

Line 1727: ,p_person_id per_people_f.person_id%TYPE default null

1723: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
1724: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
1725: ,p_process VARCHAR2
1726: ,p_itemtype VARCHAR2
1727: ,p_person_id per_people_f.person_id%TYPE default null
1728: ,p_effective_date date default null
1729: ,p_source_name VARCHAR2 default null
1730: )
1731: /******************************************************************

Line 1744: ln_person_id per_people_f.person_id%TYPE;

1740: ** Public
1741: **
1742: ******************************************************************/
1743: IS
1744: ln_person_id per_people_f.person_id%TYPE;
1745: ln_business_group_id per_people_f.business_group_id%TYPE;
1746: ln_parent_audit_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;
1747: ln_assignment_id per_assignments_f.assignment_id%TYPE;
1748: ln_gre_id hr_organization_units.organization_id%TYPE;

Line 1745: ln_business_group_id per_people_f.business_group_id%TYPE;

1741: **
1742: ******************************************************************/
1743: IS
1744: ln_person_id per_people_f.person_id%TYPE;
1745: ln_business_group_id per_people_f.business_group_id%TYPE;
1746: ln_parent_audit_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;
1747: ln_assignment_id per_assignments_f.assignment_id%TYPE;
1748: ln_gre_id hr_organization_units.organization_id%TYPE;
1749: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;

Line 1862: ln_person_id per_people_f.person_id%TYPE;

1858: ** Public
1859: **
1860: ******************************************************************/
1861: IS
1862: ln_person_id per_people_f.person_id%TYPE;
1863: ln_business_group_id per_people_f.business_group_id%TYPE;
1864: ln_parent_audit_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;
1865: ln_assignment_id per_assignments_f.assignment_id%TYPE;
1866: ln_gre_id hr_organization_units.organization_id%TYPE;

Line 1863: ln_business_group_id per_people_f.business_group_id%TYPE;

1859: **
1860: ******************************************************************/
1861: IS
1862: ln_person_id per_people_f.person_id%TYPE;
1863: ln_business_group_id per_people_f.business_group_id%TYPE;
1864: ln_parent_audit_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;
1865: ln_assignment_id per_assignments_f.assignment_id%TYPE;
1866: ln_gre_id hr_organization_units.organization_id%TYPE;
1867: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;

Line 2895: FUNCTION get_state_list(p_person_id IN per_people_f.person_id%TYPE,

2891:
2892: hr_utility.trace('Leaving package update_w4_info ');
2893: End;
2894:
2895: FUNCTION get_state_list(p_person_id IN per_people_f.person_id%TYPE,
2896: p_primary_flag IN varchar2 )
2897:
2898: RETURN VARCHAR2 IS
2899:

Line 3007: FUNCTION get_org_context(p_person_id IN per_people_f.person_id%TYPE,

3003: return lv_state_list;
3004:
3005: End;
3006:
3007: FUNCTION get_org_context(p_person_id IN per_people_f.person_id%TYPE,
3008: p_context hr_organization_information.org_information_context%TYPE,
3009: p_level IN VARCHAR2)
3010:
3011: RETURN VARCHAR2 IS

Line 3021: from per_people_f ppf,

3017: ppf.person_id,
3018: ppf.employee_number,
3019: ppf.national_identifier,
3020: ppf.full_name
3021: from per_people_f ppf,
3022: per_assignments_f paf
3023: where ppf.person_id = p_person_id
3024: and paf.person_id = ppf.person_id
3025: and paf.assignment_type = 'E'