APPS.PAY_CN_AUDIT_XMLGEN dependencies on PAY_PAYROLLS_F

Line 227: pay_payrolls_f ppf

223: CURSOR c_get_periods(p_assignment_id IN NUMBER) IS
224: select distinct(to_CHAR(ppa.effective_date,'YYYY')||TO_CHAR(ppa.effective_date,'MM')||ppf.payroll_id) pnum
225: from pay_payroll_Actions ppa,
226: pay_assignment_actions paa,
227: pay_payrolls_f ppf
228: where paa.payroll_action_id = ppa.payroll_Action_id
229: and ppa.action_type in('R','Q')
230: and ppa.payroll_id = ppf.payroll_id
231: and paa.assignment_id = p_assignment_id

Line 472: pay_payrolls_f ppf

468: to_CHAR(ptp.start_date,'YYYYMMDD') strt,
469: to_CHAR(ptp.end_date,'YYYYMMDD') ende,
470: to_CHAR(ptp.regular_payment_date,'YYYY') yr
471: FROM per_time_periods ptp,
472: pay_payrolls_f ppf
473: WHERE ptp.payroll_id = ppf.payroll_id
474: AND decode(g_trfr_date_used,'E',ptp.end_date,ptp.regular_payment_date) BETWEEN g_start_date and g_end_date
475: AND EXISTS(SELECT 1
476: FROM per_assignments_f paf

Line 490: ,pay_payrolls_f pap

486: nvl(petl.reporting_name,petl.element_name) element_name,
487: get_cost_alloc_key_flex(hoi.org_information3) exp_cat_code
488: FROM hr_organization_information hoi
489: ,hr_organization_units hou
490: ,pay_payrolls_f pap
491: ,pay_element_types_f_tl petl
492: ,pay_element_types_f pet
493: WHERE hoi.org_information_context = 'PER_CNAO_ORG_INFO'
494: AND hou.organization_id = hoi.organization_id

Line 525: ,pay_payrolls_f pap

521: nvl(PBT_TL.REPORTING_NAME,PBT_TL.BALANCE_NAME) element_name,
522: 'X' exp_cat_code
523: FROM hr_organization_information hoi
524: ,hr_organization_units hou
525: ,pay_payrolls_f pap
526: ,PAY_BALANCE_TYPES PBT, PAY_BALANCE_TYPES_TL PBT_TL
527: WHERE hoi.org_information_context = 'PER_CNAO_BAL_INFO'
528: AND hou.organization_id = hoi.organization_id
529: AND hou.business_group_id = g_bg_id

Line 559: pay_payrolls_f ppf

555: ppf.payroll_name
556: FROM per_assignments_f paf,
557: pay_payroll_actions ppa,
558: pay_assignment_actions paa,
559: pay_payrolls_f ppf
560: WHERE paf.effective_start_date <= g_end_date
561: AND paf.effective_end_date >= g_start_date
562: AND paf.business_group_id = g_bg_id
563: AND paa.assignment_id =paf.assignment_id

Line 594: (select distinct p.payroll_name from pay_payrolls_f p where p.payroll_id = paf.payroll_id) pname,

590: SELECT TO_CHAR(get_employee_number(paf.person_id,ppa.effective_date)) eno,
591: per_cn_shared_info.get_lookup_meaning(paf.employee_category,'EMPLOYEE_CATG') asg_cat ,
592: get_employee_name(paf.person_id,ppa.effective_date) emp_name,
593: to_char(paf.organization_id) asg_org_id,
594: (select distinct p.payroll_name from pay_payrolls_f p where p.payroll_id = paf.payroll_id) pname,
595: to_CHAR(ppa.effective_date,'YYYY') yr,
596: to_number(TO_CHAR(ppa.effective_date,'MM')) pno,
597: to_CHAR(decode(g_trfr_date_used,'E',ppa.date_earned,ppa.effective_date) ,'YYYY') acct_yr,
598: to_number(to_CHAR(decode(g_trfr_date_used,'E',ppa.date_earned,ppa.effective_date) ,'MM')) accnt_prd,

Line 612: from pay_payrolls_f

608:
609: CURSOR get_payroll_id(p_payroll_name IN VARCHAR2)
610: IS
611: select distinct payroll_id
612: from pay_payrolls_f
613: where payroll_name = p_payroll_name;
614:
615: v_pay_prd tab_pay_prd;
616: l_ctr NUMBER;

Line 1550: pay_payrolls_f p

1546: sqlstr := ' select paa.rowid
1547: from pay_assignment_actions paa,
1548: pay_payroll_actions ppa ,
1549: per_people_f ppf,
1550: pay_payrolls_f p
1551: where ppa.payroll_action_id = :pactid
1552: and paa.payroll_action_id = ppa.payroll_action_id
1553: AND '''||g_end_date||''' between p.effective_start_date and p.effective_end_date
1554: and '''||g_end_date||''' BETWEEN ppf.effective_start_date AND ppf.effective_end_date