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_CA_ARCHIVE dependencies on PAY_PAYROLLS_F

Line 1933: from pay_payrolls_f ppf,

1929: ppf.prl_information4 correspondence_language,
1930: people1.first_name contact_first_name,
1931: people1.middle_names contact_middle_names,
1932: people1.last_name contact_last_name
1933: from pay_payrolls_f ppf,
1934: per_people_f people1,
1935: per_people_f people2
1936: where ppf.payroll_id = l_payroll_id
1937: and ppf.prl_information_category = 'CA'

Line 2098: l_roe_contact_phone_number pay_payrolls_f.prl_information2%TYPE;

2094: l_roe_contact_person per_people_f.full_name%TYPE;
2095: l_roe_contact_first_name per_people_f.first_name%TYPE;
2096: l_roe_contact_middle_names per_people_f.middle_names%TYPE;
2097: l_roe_contact_last_name per_people_f.last_name%TYPE;
2098: l_roe_contact_phone_number pay_payrolls_f.prl_information2%TYPE;
2099: l_roe_issuer pay_payrolls_f.prl_information4%TYPE;
2100: l_roe_correspondence_language per_people_f.full_name%TYPE;
2101: l_pay_period_end_date date;
2102: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

Line 2099: l_roe_issuer pay_payrolls_f.prl_information4%TYPE;

2095: l_roe_contact_first_name per_people_f.first_name%TYPE;
2096: l_roe_contact_middle_names per_people_f.middle_names%TYPE;
2097: l_roe_contact_last_name per_people_f.last_name%TYPE;
2098: l_roe_contact_phone_number pay_payrolls_f.prl_information2%TYPE;
2099: l_roe_issuer pay_payrolls_f.prl_information4%TYPE;
2100: l_roe_correspondence_language per_people_f.full_name%TYPE;
2101: l_pay_period_end_date date;
2102: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
2103: l_latest_aaid pay_assignment_actions.assignment_action_id%TYPE