DBA Data[Home] [Help]

APPS.PAY_CN_AUDIT_XMLGEN dependencies on PAY_ALL_PAYROLLS_F

Line 880: from pay_all_payrolls_f pap

876: pet.element_type_id eid,
877: trim(to_char(fnd_number.canonical_to_number(pai.action_information5),'999999990.99')) current_amount
878: from pay_action_information pai,
879: (select pap.payroll_name
880: from pay_all_payrolls_f pap
881: where pap.payroll_id = p_payroll_id
882: AND g_end_date BETWEEN pap.effective_start_date AND pap.effective_end_date) pname,
883: (SELECT ppf.employee_number
884: FROM per_all_people_f ppf,

Line 922: from pay_all_payrolls_f pap

918: pbt.balance_type_id eid,
919: trim(to_char(fnd_number.canonical_to_number(pai.action_information6),'999999990.99')) current_amount
920: from pay_action_information pai,
921: (select pap.payroll_name
922: from pay_all_payrolls_f pap
923: where pap.payroll_id = p_payroll_id
924: AND g_end_date BETWEEN pap.effective_start_date AND pap.effective_end_date) pname,
925: (SELECT ppf.employee_number
926: FROM per_all_people_f ppf,

Line 973: from pay_all_payrolls_f pap

969: pbt.balance_type_id eid,
970: trim(to_char(fnd_number.canonical_to_number(pai.action_information5),'999999990.99')) current_amount
971: from pay_action_information pai,
972: (select pap.payroll_name
973: from pay_all_payrolls_f pap
974: where pap.payroll_id = p_payroll_id
975: AND g_end_date BETWEEN pap.effective_start_date AND pap.effective_end_date) pname,
976: (SELECT ppf.employee_number
977: FROM per_all_people_f ppf,