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

Line 778: l_first_name per_people_f.first_name%type;

774:
775: -- #2938556
776: l_assignment_number per_assignments_f.assignment_number%type;
777: l_person_id per_assignments_f.person_id%type;
778: l_first_name per_people_f.first_name%type;
779: l_middle_name per_people_f.middle_names%type;
780: l_last_name per_people_f.last_name%type;
781: l_ssn per_people_f.national_identifier%type;
782: l_prev_asg_act_id pay_assignment_actions.assignment_action_id%type;

Line 779: l_middle_name per_people_f.middle_names%type;

775: -- #2938556
776: l_assignment_number per_assignments_f.assignment_number%type;
777: l_person_id per_assignments_f.person_id%type;
778: l_first_name per_people_f.first_name%type;
779: l_middle_name per_people_f.middle_names%type;
780: l_last_name per_people_f.last_name%type;
781: l_ssn per_people_f.national_identifier%type;
782: l_prev_asg_act_id pay_assignment_actions.assignment_action_id%type;
783: new_asg_act_id pay_assignment_actions.assignment_action_id%type;

Line 780: l_last_name per_people_f.last_name%type;

776: l_assignment_number per_assignments_f.assignment_number%type;
777: l_person_id per_assignments_f.person_id%type;
778: l_first_name per_people_f.first_name%type;
779: l_middle_name per_people_f.middle_names%type;
780: l_last_name per_people_f.last_name%type;
781: l_ssn per_people_f.national_identifier%type;
782: l_prev_asg_act_id pay_assignment_actions.assignment_action_id%type;
783: new_asg_act_id pay_assignment_actions.assignment_action_id%type;
784: l_count number := 1;

Line 781: l_ssn per_people_f.national_identifier%type;

777: l_person_id per_assignments_f.person_id%type;
778: l_first_name per_people_f.first_name%type;
779: l_middle_name per_people_f.middle_names%type;
780: l_last_name per_people_f.last_name%type;
781: l_ssn per_people_f.national_identifier%type;
782: l_prev_asg_act_id pay_assignment_actions.assignment_action_id%type;
783: new_asg_act_id pay_assignment_actions.assignment_action_id%type;
784: l_count number := 1;
785: l_bal_id number;

Line 883: ,per_people_f ppf

879: ,l_middle_name
880: ,l_last_name
881: ,l_ssn
882: from per_assignments_f paf
883: ,per_people_f ppf
884: where paf.assignment_id = p_asg_id
885: and paf.effective_end_date = ( select max(paf1.effective_end_date)
886: from per_assignments_f paf1
887: where paf1.assignment_id = paf.assignment_id

Line 1081: l_first_name per_people_f.first_name%type;

1077:
1078: -- #2938556
1079: l_assignment_number per_assignments_f.assignment_number%type;
1080: l_person_id per_assignments_f.person_id%type;
1081: l_first_name per_people_f.first_name%type;
1082: l_middle_name per_people_f.middle_names%type;
1083: l_last_name per_people_f.last_name%type;
1084: l_ssn per_people_f.national_identifier%type;
1085: l_fed_401k_catchup_limit number;

Line 1082: l_middle_name per_people_f.middle_names%type;

1078: -- #2938556
1079: l_assignment_number per_assignments_f.assignment_number%type;
1080: l_person_id per_assignments_f.person_id%type;
1081: l_first_name per_people_f.first_name%type;
1082: l_middle_name per_people_f.middle_names%type;
1083: l_last_name per_people_f.last_name%type;
1084: l_ssn per_people_f.national_identifier%type;
1085: l_fed_401k_catchup_limit number;
1086: l_fed_403b_catchup_limit number;

Line 1083: l_last_name per_people_f.last_name%type;

1079: l_assignment_number per_assignments_f.assignment_number%type;
1080: l_person_id per_assignments_f.person_id%type;
1081: l_first_name per_people_f.first_name%type;
1082: l_middle_name per_people_f.middle_names%type;
1083: l_last_name per_people_f.last_name%type;
1084: l_ssn per_people_f.national_identifier%type;
1085: l_fed_401k_catchup_limit number;
1086: l_fed_403b_catchup_limit number;
1087: l_fed_457_catchup_limit number;

Line 1084: l_ssn per_people_f.national_identifier%type;

1080: l_person_id per_assignments_f.person_id%type;
1081: l_first_name per_people_f.first_name%type;
1082: l_middle_name per_people_f.middle_names%type;
1083: l_last_name per_people_f.last_name%type;
1084: l_ssn per_people_f.national_identifier%type;
1085: l_fed_401k_catchup_limit number;
1086: l_fed_403b_catchup_limit number;
1087: l_fed_457_catchup_limit number;
1088: l_dcp_limit number;

Line 1345: ,per_people_f ppf

1341: ,l_middle_name
1342: ,l_last_name
1343: ,l_ssn
1344: from per_assignments_f paf
1345: ,per_people_f ppf
1346: where paf.assignment_id = p_asg_id
1347: and paf.effective_end_date = ( select max(paf1.effective_end_date)
1348: from per_assignments_f paf1
1349: where paf1.assignment_id = paf.assignment_id