APPS.PAY_JP_SPR_EFILE_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 50: dpnt_ref_type pay_all_payrolls_f.prl_information1%type,

46: date_earned date,
47: itax_organization_id number,
48: itax_category pay_jp_pre_tax.itax_category%type,
49: itax_yea_category pay_jp_pre_tax.itax_yea_category%type,
50: dpnt_ref_type pay_all_payrolls_f.prl_information1%type,
51: dpnt_effective_date date,
52: person_id number,
53: sex per_all_people_f.sex%type,
54: date_of_birth date,

Line 170: dpnt_ref_type pay_all_payrolls_f.prl_information1%type,

166: date_earned date,
167: itax_organization_id number,
168: itax_category pay_jp_pre_tax.itax_category%type,
169: itax_yea_category pay_jp_pre_tax.itax_yea_category%type,
170: dpnt_ref_type pay_all_payrolls_f.prl_information1%type,
171: dpnt_effective_date date,
172: person_id number,
173: sex per_all_people_f.sex%type,
174: date_of_birth date,

Line 682: pay_all_payrolls_f pap,

678: pp.employee_number
679: from pay_payroll_actions ppa,
680: pay_assignment_actions paa,
681: pay_jp_wic_assacts_v pjwa,
682: pay_all_payrolls_f pap,
683: per_all_people_f pp,
684: per_addresses padr,
685: per_addresses padc
686: where ppa.payroll_action_id = :p_payroll_action_id