APPS.PAY_IN_TERM_RPRT_GEN_PKG dependencies on PER_ASSIGNMENTS_F

Line 339: ,per_assignments_f paf

335: ,hou.name department
336: ,org.name ORGANIZATION
337: ,loc.location_code location
338: FROM per_people_f ppf
339: ,per_assignments_f paf
340: ,per_periods_of_service ppos
341: ,hr_soft_coding_keyflex hsck
342: ,hr_organization_units hou
343: ,hr_organization_units org

Line 368: ,per_assignments_f paf

364: SELECT nvl(pp.name,pj.name) designation
365: FROM per_positions pp
366: ,per_jobs pj
367: ,per_people_f ppf
368: ,per_assignments_f paf
369: ,per_periods_of_service ppos
370: WHERE ppf.business_group_id = p_bus_grp_id
371: AND ppf.employee_number = p_employee_number
372: AND ppf.person_id = paf.person_id

Line 402: FROM per_assignments_f paf

398: SELECT nvl(pet.reporting_name, pet.element_name) description
399: ,sum(prrv.result_value) amount
400: ,pec.classification_name classification
401: ,pet.element_name elename
402: FROM per_assignments_f paf
403: ,per_people_f ppf
404: ,pay_element_types_f pet
405: ,pay_input_values_f piv
406: ,pay_assignment_actions paa

Line 461: ,per_assignments_f paf

457: SELECT max(paa.assignment_action_id)
458: FROM pay_assignment_actions paa
459: ,pay_payroll_actions ppa
460: ,per_people_f ppf
461: ,per_assignments_f paf
462: ,per_periods_of_service ppos
463: WHERE ppf.employee_number = p_employee_number
464: AND ppf.person_id = paf.person_id
465: AND paf.period_of_service_id = ppos.period_of_service_id

Line 517: ,per_assignments_f paf

513: SELECT max(paa.assignment_action_id)
514: FROM pay_assignment_actions paa
515: ,pay_payroll_actions ppa
516: ,per_people_f ppf
517: ,per_assignments_f paf
518: ,per_periods_of_service ppos
519: WHERE ppf.employee_number = p_employee_number
520: AND ppf.person_id = paf.person_id
521: AND paf.period_of_service_id = ppos.period_of_service_id

Line 549: ,per_assignments_f paf

545: SELECT max(paa.assignment_action_id)
546: FROM pay_assignment_actions paa
547: ,pay_payroll_actions ppa
548: ,per_people_f ppf
549: ,per_assignments_f paf
550: ,per_periods_of_service ppos
551: WHERE ppf.employee_number = p_employee_number
552: AND ppf.person_id = paf.person_id
553: AND paf.period_of_service_id = ppos.period_of_service_id

Line 582: ,per_assignments_f paf

578: SELECT max(paa.assignment_action_id)
579: FROM pay_assignment_actions paa
580: ,pay_payroll_actions ppa
581: ,per_people_f ppf
582: ,per_assignments_f paf
583: ,per_periods_of_service ppos
584: WHERE ppf.employee_number = p_employee_number
585: AND ppf.person_id = paf.person_id
586: AND paf.period_of_service_id = ppos.period_of_service_id

Line 615: FROM per_assignments_f paf

611: IS
612: SELECT piv.name description
613: ,INITCAP(peev.screen_entry_value) loan_type
614: ,prrv.result_value amount
615: FROM per_assignments_f paf
616: ,per_people_f ppf
617: ,pay_element_types_f pet
618: ,pay_input_values_f piv
619: ,pay_element_entries_f pee

Line 671: FROM per_assignments_f paf

667: ,p_asg_action_id NUMBER)
668: IS
669: SELECT piv.name description
670: ,prrv.result_value amount
671: FROM per_assignments_f paf
672: ,per_people_f ppf
673: ,pay_element_types_f pet
674: ,pay_input_values_f piv
675: ,pay_element_entries_f pee

Line 727: FROM per_assignments_f paf

723: ,p_max_asg_id NUMBER)
724: IS
725: SELECT prrv.result_value amount
726: ,piv.name description
727: FROM per_assignments_f paf
728: ,per_people_f ppf
729: ,pay_element_types_f pet
730: ,pay_input_values_f piv
731: ,pay_assignment_actions paa

Line 783: FROM per_assignments_f paf

779: IS
780: SELECT piv.name description
781: ,prrv.result_value amount
782: ,nvl(pet.reporting_name, pet.element_name) Element
783: FROM per_assignments_f paf
784: ,per_people_f ppf
785: ,pay_element_types_f pet
786: ,pay_input_values_f piv
787: ,pay_assignment_actions paa

Line 835: FROM per_assignments_f paf

831: IS
832: SELECT piv.name description
833: ,prrv.result_value amount
834: ,nvl(pet.reporting_name, pet.element_name) Element
835: FROM per_assignments_f paf
836: ,per_people_f ppf
837: ,pay_element_types_f pet
838: ,pay_input_values_f piv
839: ,pay_assignment_actions paa

Line 884: FROM per_assignments_f paf

880: IS
881: SELECT sum(prrv.result_value) amount
882: ,nvl(pet.reporting_name, pet.element_name) description
883: ,pet.element_name elename
884: FROM per_assignments_f paf
885: ,per_people_f ppf
886: ,pay_element_types_f pet
887: ,pay_input_values_f piv
888: ,pay_assignment_actions paa

Line 947: FROM per_assignments_f paf

943: ,p_max_asg_id NUMBER)
944: IS
945: SELECT /*+ ORDERED */
946: SUM(ABS(fnd_number.canonical_to_number(prrv.result_value))) amount
947: FROM per_assignments_f paf
948: ,per_people_f ppf
949: ,pay_element_types_f pet
950: ,pay_input_values_f piv
951: ,pay_assignment_actions paa

Line 992: FROM per_assignments_f paf

988: IS
989: SELECT to_number(pay_balance_pkg.get_value(pdb.defined_balance_id
990: , paa.assignment_action_id)) amount
991: , pbt.balance_name description
992: FROM per_assignments_f paf
993: ,per_people_f ppf
994: ,pay_assignment_actions paa
995: ,per_periods_of_service ppos
996: ,pay_balance_types pbt

Line 1036: ,per_assignments_f paf

1032: ,pay_action_interlocks pci
1033: ,pay_payroll_actions ppa
1034: ,pay_assignment_actions paa
1035: ,per_people_f ppf
1036: ,per_assignments_f paf
1037: ,per_periods_of_service ppos
1038: WHERE ppp.assignment_action_id = pci.locking_action_id
1039: AND ppp.personal_payment_method_id = ppm.personal_payment_method_id (+)
1040: AND ppp.org_payment_method_id = pop.org_payment_method_id

Line 1071: FROM per_assignments_f paf

1067: IS
1068: SELECT to_number(pay_balance_pkg.get_value(pdb.defined_balance_id
1069: , paa.assignment_action_id)) amount
1070: , pbt.balance_name description
1071: FROM per_assignments_f paf
1072: ,per_people_f ppf
1073: ,pay_assignment_actions paa
1074: ,per_periods_of_service ppos
1075: ,pay_balance_types pbt