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_US_WEB_W4 dependencies on PER_PEOPLE_F

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

574: END IF; -- State Following Federal Or NOT
575:
576: END Fed_State_Filing_Status_Match;
577:
578: FUNCTION check_update_status(p_person_id IN per_people_f.person_id%TYPE)
579: RETURN VARCHAR2
580: /******************************************************************
581: **
582: ** Description:

Line 795: ln_person_id per_people_f.person_id%TYPE;

791: l_additional_tax pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE;
792: l_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
793: l_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
794: l_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
795: ln_person_id per_people_f.person_id%TYPE;
796: ln_business_group_id per_people_f.business_group_id%TYPE;
797: ln_organization_id hr_organization_information.organization_id%TYPE;
798: lr_org_info_rec hr_organization_information%ROWTYPE;
799: -- lrr_item_rec pay_us_misc_web.item_attr_rec;

Line 796: ln_business_group_id per_people_f.business_group_id%TYPE;

792: l_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
793: l_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
794: l_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
795: ln_person_id per_people_f.person_id%TYPE;
796: ln_business_group_id per_people_f.business_group_id%TYPE;
797: ln_organization_id hr_organization_information.organization_id%TYPE;
798: lr_org_info_rec hr_organization_information%ROWTYPE;
799: -- lrr_item_rec pay_us_misc_web.item_attr_rec;
800: lv_has_errors VARCHAR2(1) := 'N';

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

1582: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
1583: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
1584: ,p_process VARCHAR2
1585: ,p_itemtype VARCHAR2
1586: ,p_person_id per_people_f.person_id%TYPE default null
1587: ,p_effective_date date default null
1588: ,p_source_name VARCHAR2 default null
1589: )
1590: /******************************************************************

Line 1603: ln_person_id per_people_f.person_id%TYPE;

1599: ** Public
1600: **
1601: ******************************************************************/
1602: IS
1603: ln_person_id per_people_f.person_id%TYPE;
1604: ln_business_group_id per_people_f.business_group_id%TYPE;
1605: ln_parent_audit_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;
1606: ln_assignment_id per_assignments_f.assignment_id%TYPE;
1607: ln_gre_id hr_organization_units.organization_id%TYPE;

Line 1604: ln_business_group_id per_people_f.business_group_id%TYPE;

1600: **
1601: ******************************************************************/
1602: IS
1603: ln_person_id per_people_f.person_id%TYPE;
1604: ln_business_group_id per_people_f.business_group_id%TYPE;
1605: ln_parent_audit_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;
1606: ln_assignment_id per_assignments_f.assignment_id%TYPE;
1607: ln_gre_id hr_organization_units.organization_id%TYPE;
1608: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;

Line 1721: ln_person_id per_people_f.person_id%TYPE;

1717: ** Public
1718: **
1719: ******************************************************************/
1720: IS
1721: ln_person_id per_people_f.person_id%TYPE;
1722: ln_business_group_id per_people_f.business_group_id%TYPE;
1723: ln_parent_audit_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;
1724: ln_assignment_id per_assignments_f.assignment_id%TYPE;
1725: ln_gre_id hr_organization_units.organization_id%TYPE;

Line 1722: ln_business_group_id per_people_f.business_group_id%TYPE;

1718: **
1719: ******************************************************************/
1720: IS
1721: ln_person_id per_people_f.person_id%TYPE;
1722: ln_business_group_id per_people_f.business_group_id%TYPE;
1723: ln_parent_audit_id pay_stat_trans_audit.stat_trans_audit_id%TYPE;
1724: ln_assignment_id per_assignments_f.assignment_id%TYPE;
1725: ln_gre_id hr_organization_units.organization_id%TYPE;
1726: ln_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;

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

2720:
2721: hr_utility.trace('Leaving package update_w4_info ');
2722: End;
2723:
2724: FUNCTION get_state_list(p_person_id IN per_people_f.person_id%TYPE,
2725: p_primary_flag IN varchar2 )
2726:
2727: RETURN VARCHAR2 IS
2728:

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

2822: return lv_state_list;
2823:
2824: End;
2825:
2826: FUNCTION get_org_context(p_person_id IN per_people_f.person_id%TYPE,
2827: p_context hr_organization_information.org_information_context%TYPE,
2828: p_level IN VARCHAR2)
2829:
2830: RETURN VARCHAR2 IS

Line 2840: from per_people_f ppf,

2836: ppf.person_id,
2837: ppf.employee_number,
2838: ppf.national_identifier,
2839: ppf.full_name
2840: from per_people_f ppf,
2841: per_assignments_f paf
2842: where ppf.person_id = p_person_id
2843: and paf.person_id = ppf.person_id
2844: and paf.assignment_type = 'E'